Edit D:\app\Administrator\product\11.2.0\dbhome_1\jlib\oracle\sysman\vdu\VduSQL.class

??���/�?
��l�m�n�sql_registerObject�Ljava/lang/String;�
ConstantValue�o�sql_deleteObject�p�sql_grantPrivilege�q�sql_updatePrivilege�r�sql_revokePrivilege�s�sql_revokePrivileges�t�sql_revokeAllAccess�u�sql_retreiveOID�v�sql_retreivePrincipalOID�w�sql_getPrincipalsForOID�x�sql_getObjectsForOID�y�sql_getObjectsForOIDUnowned�z�sql_getObjects�{�sql_checkPrivilege�|�sql_authenticatePrincipal�}�%sql_authenticatePrincipal_returnIndex�I����'sql_authenticatePrincipal_userNameIndex����!sql_authenticatePrincipal_suIndex����*sql_authenticatePrincipal_accessToJobIndex����,sql_authenticatePrincipal_accessToEventIndex����#sql_authenticatePrincipal_typeIndex����%sql_authenticatePrincipal_passwdIndex����sql_getPrincipalDetails�~�sql_getPrincipalDetails_suIndex�(sql_getPrincipalDetails_accessToJobIndex�*sql_getPrincipalDetails_accessToEventIndex�sql_getAllUserDetails��sql_getAllUserDetails_userIndex�sql_getAllUserDetails_suIndex�&sql_getAllUserDetails_accessToJobIndex�(sql_getAllUserDetails_accessToEventIndex�sql_validPrincipal�?�sql_createPrincipal�?�sql_getPrincipalNames�?�sql_removePrincipal�?�sql_getRawPassword�?�sql_isSuperUser�?�sql_getAllUsersWithIDs�?�sql_getAllUsers�?�sql_getAllSuperusers�?�sql_getAllJobEventUsers�?�sql_getPrivileges�?�sql_selectObjectsForUpdate�?�sql_updateObjectOwnership�?�sql_getOwnedObjectsOfType�?�sql_getPrivilegeGrid�?�sql_getObjectsForType�?�sql_getOwnedObjectsForType�?�sql_getUnOwnedObjectsForType�?�Object_Name_Col_Name�?�"sql_getObjectsForType_NameFiltered�?�<init>�()V�Code�LineNumberTable�
SourceFile�VduSQL.java�f�g�oracle/sysman/vdu/VduSQL�java/lang/Object�zinsert into SMP_VDU_OBJECTS_TABLE (object_id, type, owner, object_name) values (SMP_VDU_OBJECTS_SEQUENCE.NEXTVAL, ?, ?, ?)�Rdelete from SMP_VDU_OBJECTS_TABLE where type = ? AND owner = ? AND object_name = ?]insert into SMP_VDU_PRIVILEGE_TABLE (select principals.principal_id, ?, objects.object_id from smp_vdu_principals_table principals, smp_vdu_objects_table objects where upper(principals.type) = upper(?) AND upper(principals.principal_name) = upper(?) and upper(objects.type) = upper(?) AND upper(objects.owner) = upper(?) AND objects.object_name = ?)/update SMP_VDU_PRIVILEGE_TABLE set privilege_string = ? where object_oid in (select object_id from smp_vdu_objects_table where upper(type)=upper(?) and upper(owner)=upper(?) and object_name=?) and principal_oid in (select principal_id from smp_vdu_principals_table where upper(principal_name)=upper(?)) �gdelete from SMP_VDU_PRIVILEGE_TABLE where principal_oid = ? AND privilege_string = ? AND object_oid = ?delete from SMP_VDU_PRIVILEGE_TABLE where principal_oid in (select principal_id from smp_vdu_principals_table where (%s)) and object_oid in (select object_id from smp_vdu_objects_table where upper(type)=upper(?) and upper(owner)=upper(?) and object_name=?) delete from SMP_VDU_PRIVILEGE_TABLE where  principal_oid IN (select principal_id from smp_vdu_principals_table where principal_name = ? AND type = ?) AND  object_oid IN (select object_id from SMP_VDU_OBJECTS_TABLE where type = ? AND owner = ? AND object_name = ?)�\select object_id from SMP_VDU_OBJECTS_TABLE where type = ? AND owner = ? AND object_name = ?�Wselect principal_id from SMP_VDU_PRINCIPALS_TABLE where type = ? AND principal_name = ?�?elect type, principal_name from smp_vdu_principals_table where principal_id IN (select principal_oid from smp_vdu_privilege_table where (object_oid = ? and privilege_string = ?) or (privilege_string = 'IS' and object_oid = ?))�?elect type, owner, object_name from smp_vdu_objects_table where object_id IN (select object_oid from smp_vdu_privilege_table where principal_oid = ? AND privilege_string = ?)�?elect type, owner, object_name from smp_vdu_objects_table where owner != ? AND object_id IN (select object_oid from smp_vdu_privilege_table where principal_oid = ? AND privilege_string = ?)�:select type, owner, object_name from smp_vdu_objects_table�pselect count(*) from smp_vdu_privilege_table where principal_oid = ? and privilege_string = ? and object_oid = ?�3begin ? := SMP_VDU.getUserDetail(?,?,?,?,?,?); end;�:begin ? := SMP_VDU.getListUserDetails(?, ?, ?, ?, ?); end;�.begin SMP_VDU.getAllUserDetails(?,?,?,?); end;�Rselect principal_name, type from smp_vdu_principals_table where principal_name = ?�?nsert into smp_vdu_principals_table (principal_id, type, principal_name, password) values (smp_vdu_principals_sequence.NEXTVAL, ?, ?, ?)�3select principal_name from smp_vdu_principals_table�=delete from smp_vdu_principals_table where principal_name = ?�Fselect password from smp_vdu_principals_table where principal_name = ?Jselect count(*) from smp_vdu_privilege_table where principal_oid in (select principal_id from SMP_VDU_PRINCIPALS_TABLE where type = ? AND principal_name = ?) AND object_oid in (select object_id from SMP_VDU_OBJECTS_TABLE where type = 'OEM_SUBSYSTEM' AND owner = 'OEM' AND object_name = 'OEM_SUPERUSER') AND privilege_string = 'IS'�Wselect principal_name, principal_id from smp_view_vdu_administrators where superuser=0 �Iselect principal_name from smp_view_vdu_administrators where superuser=0 �?elect principal_name from SMP_VDU_PRINCIPALS_TABLE where principal_id IN ( select distinct(principal_oid) from SMP_VDU_PRIVILEGE_TABLE where privilege_string = 'IS') order by principal_name�yselect principal_name from smp_view_vdu_administrators where (superuser = 1) or ((job_system = 1) and (event_system = 1))@select privilege.privilege_string from smp_vdu_privilege_table privilege where (privilege.principal_oid = (select principal_id from smp_vdu_principals_table where type = ? AND principal_name = ?)) AND (privilege.object_oid = (select object_id from smp_vdu_objects_table where type = ? AND owner = ? AND object_name = ?))�gselect object_id from smp_vdu_objects_table where type = ? and owner = ? and object_name = ? for update�>update smp_vdu_objects_table set owner = ? where object_id = ?�Jselect object_name from smp_vdu_objects_table where owner = ? and type = ?SELECT p.PRINCIPAL_NAME, o.TYPE, o.OBJECT_NAME, v.PRIVILEGE_STRING FROM SMP_VDU_OBJECTS_TABLE o, SMP_VDU_PRINCIPALS_TABLE p, SMP_VDU_PRIVILEGE_TABLE v WHERE (p.PRINCIPAL_ID = v.PRINCIPAL_OID) AND (v.OBJECT_OID  = o.OBJECT_ID) AND ((o.OBJECT_ID=? AND o.OBJECT_NAME = ? AND o.TYPE = ?) OR (o.TYPE='OEM_SUBSYSTEM')) UNION select p.PRINCIPAL_NAME, ?, ?, 'NONE' from SMP_VDU_PRIVILEGE_TABLE v, SMP_VDU_PRINCIPALS_TABLE p where p.PRINCIPAL_ID NOT IN (select principal_oid from smp_vdu_privilege_table) ORDER BY PRINCIPAL_NAME�JSELECT type, owner, object_name from smp_vdu_objects_table where type = ? �?ELECT type, owner, object_name from smp_vdu_objects_table where type = ? AND object_id IN (select object_oid from smp_vdu_privilege_table where principal_oid = ? AND privilege_string IN (%s))�?ELECT type, owner, object_name from smp_vdu_objects_table where type = ? AND owner != ? AND object_id IN (select object_oid from smp_vdu_privilege_table where principal_oid = ? AND privilege_string IN (%s))�object_name�?ELECT type, owner, object_name from smp_vdu_objects_table where type = ? AND object_id IN (SELECT object_oid FROM smp_vdu_privilege_table WHERE principal_oid = ? AND privilege_string IN (%s))  AND �1�����3������������������	��
����������������
����������������������������������������������������������������������������������� �������!��"�������#��$�%������&��'�%������(��)�%������*��+�%������,��-�%������.��/�%������0��1�%������2��3�������4��5�%������*��6�%������,��7�%������.��8�������9��:�%������&��;�%������(��<�%������*��=�%������,��>�������?��@�������A��B�������C��D�������E��F�������G��H�������I��J�������K��L�������M��N�������O��P�������Q��R�������S��T�������U��V�������W��X�������Y��Z�������[��\�������]��^�������_��`�������a��b�������c��d�������e���f�g��h��������*?�?����i�������N��j����k

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de