/ -STU V ,WX ,YZ S[ \]^_ ` ,abc ,def ,ghij ,klmn ,opqr ,st ,uv ,wx ,yz{ ,|}~ tableAONotifyLjava/lang/String; tableAObjectssql_getNotificationListsql_insertNotifyStatesql_deleteNotifyStatesql_selectNotifyStateForUpdatesql_updateNotifyStateForUpdatesql_getObjectIdsql_insertObjectsql_deleteObjectsql_updateObjectsql_getPrivileges ConstantValuesql_getDefaultPrivilegessql_getPrivilegesAndNotifyPrefs&sql_getDefaultPrivilegesAndNotifyPrefssql_deleteUsersql_getPropertiessql_deleteAllPropertiessql_insertPropertysql_versionUpdateProc()VCodeLineNumberTable SourceFile VdiSql.java LMjava/lang/Stringsmp_vdi_aobject_notification L ./smp_vdi_object_table 0/java/lang/StringBufferselect username, notify from  where object_id =  (select object_id from 2 where type = ? and owner = ? and object_name = ?) 1/ insert into  values( ?, ?, 1) 2/ delete from  where object_id=? and 3/select * from  where object_id = ? and  username = ? for update 4/update ( set notify = ? where object_id = ? and  username = ? 5/select object_id from  where type = ? and owner = ?  and object_name = ? 6/ (object_id, type, owner, object_name, version) select object_id, type, owner, object_name, 0 from smp_vdu_objects_table where upper(type)=upper(?) and upper(owner)=upper(?) and upper(object_name)=upper(?) 7/1 where type = ? and owner = ? and object_name = ? 8/i set owner = ? where lower(type) = lower(?) and lower(owner) = lower(?) and lower(object_name) = lower(?) 9/% where username = ? and object_id in 3 where object_name = ? and type = ? and owner = ?) C/!oracle/sysman/vdiBaseComps/VdiSqljava/lang/Object SELECT usr.principal_name "USERNAME", DECODE(pr1.privilege_string,'IS',1,0) "ISSUPERUSER", DECODE(pr2.privilege_string,'ALL',1,0) "ACCESSTOJOB", DECODE(pr3.privilege_string,'ALL',1,0) "ACCESSTOEVENT", DECODE(pr1.privilege_string,'IS', 'FULL', NVL(priv.privilege_string,'NONE')) "PRIVILEGE" FROM SMP_VDU_PRIVILEGE_TABLE priv, SMP_VDU_PRIVILEGE_TABLE pr1, SMP_VDU_PRIVILEGE_TABLE pr2, SMP_VDU_PRIVILEGE_TABLE pr3, (SELECT objs.object_id, objs.owner, admn.principal_id, admn.principal_name FROM SMP_VDU_OBJECTS_TABLE objs, SMP_VDU_PRINCIPALS_TABLE admn WHERE upper(objs.object_name) = upper(?) AND upper(objs.TYPE) = upper(?) AND upper(objs.owner) = upper(?) ) usr WHERE usr.principal_id = priv.principal_oid (+) AND usr.object_id = priv.object_oid (+) AND usr.principal_id = pr1.principal_oid (+) AND usr.principal_id = pr2.principal_oid (+) AND usr.principal_id = pr3.principal_oid (+) AND 1 = pr1.object_oid (+) AND 2 = pr2.object_oid (+) AND 3 = pr3.object_oid (+)  SELECT usr.otherusername "OTHERUSERNAME", DECODE(pr1.privilege_string,'IS',1,0) "ISSUPERUSER", DECODE(pr2.privilege_string,'ALL',1,0) "ACCESSTOJOB", DECODE(pr3.privilege_string,'ALL',1,0) "ACCESSTOEVENT", DECODE(pr1.privilege_string,'IS', 'FULL', NVL(priv.permission,'NONE')) "PRIVILEGE" FROM SMP_VDV_DEFAULT_PERMISSIONS priv, SMP_VDU_PRIVILEGE_TABLE pr1, SMP_VDU_PRIVILEGE_TABLE pr2, SMP_VDU_PRIVILEGE_TABLE pr3, (select p1.principal_id "USER_ID", p2.principal_name "OTHERUSERNAME", p2.principal_id "OTHER_USER_ID" from smp_vdu_principals_table p1, smp_vdu_principals_table p2 where upper(p1.principal_name)=upper(?)) usr WHERE usr.user_id=priv.user_id (+) AND usr.other_user_id=priv.other_user_id (+) AND usr.other_user_id = pr1.principal_oid (+) AND usr.other_user_id = pr2.principal_oid (+) AND usr.other_user_id = pr3.principal_oid (+) AND 1 = pr1.object_oid (+) AND 2 = pr2.object_oid (+) AND 3 = pr3.object_oid (+)  SELECT usr.principal_name "USERNAME", DECODE(pr1.privilege_string,'IS',1,0) "ISSUPERUSER", DECODE(pr2.privilege_string,'ALL',1,0) "ACCESSTOJOB", DECODE(pr3.privilege_string,'ALL',1,0) "ACCESSTOEVENT", DECODE(pr1.privilege_string,'IS','FULL', NVL(priv.privilege_string,'NONE')) "PRIVILEGE", NVL(noti.notify,0) "NOTIFY" FROM SMP_VDU_PRIVILEGE_TABLE priv, SMP_VDU_PRIVILEGE_TABLE pr1, SMP_VDU_PRIVILEGE_TABLE pr2, SMP_VDU_PRIVILEGE_TABLE pr3, SMP_VDI_AOBJECT_NOTIFICATION noti, (SELECT objs.object_id, objs.owner, admn.principal_id, admn.principal_name FROM SMP_VDU_OBJECTS_TABLE objs, SMP_VDU_PRINCIPALS_TABLE admn WHERE upper(objs.object_name) = upper(?) AND upper(objs.TYPE) = upper(?) AND upper(objs.owner) = upper(?) ) usr WHERE usr.principal_id = priv.principal_oid (+) AND usr.object_id = priv.object_oid (+) AND usr.principal_name = noti.username (+) AND usr.object_id = noti.object_id (+) AND usr.principal_id = pr1.principal_oid (+) AND usr.principal_id = pr2.principal_oid (+) AND usr.principal_id = pr3.principal_oid (+) AND 1 = pr1.object_oid (+) AND 2 = pr2.object_oid (+) AND 3 = pr3.object_oid (+) o SELECT usr.otherusername "OTHERUSERNAME", DECODE(pr1.privilege_string,'IS',1,0) "ISSUPERUSER", DECODE(pr2.privilege_string,'ALL',1,0) "ACCESSTOJOB", DECODE(pr3.privilege_string,'ALL',1,0) "ACCESSTOEVENT", DECODE(pr1.privilege_string,'IS', 'FULL', NVL(priv.permission,'NONE')) "PRIVILEGE", NVL(prefs.notify, 0) "NOTIFY" FROM SMP_VDV_DEFAULT_PERMISSIONS priv, SMP_VDV_DEFAULT_NOTIFY_PREFS prefs, SMP_VDU_PRIVILEGE_TABLE pr1, SMP_VDU_PRIVILEGE_TABLE pr2, SMP_VDU_PRIVILEGE_TABLE pr3, (select p1.principal_id "USER_ID", p2.principal_name "OTHERUSERNAME", p2.principal_id "OTHER_USER_ID" from smp_vdu_principals_table p1, smp_vdu_principals_table p2 where upper(p1.principal_name)=upper(?)) usr WHERE usr.user_id=priv.user_id (+) AND usr.other_user_id=priv.other_user_id (+) AND usr.user_id=prefs.user_id (+) AND usr.other_user_id=prefs.other_user_id (+) AND usr.other_user_id = pr1.principal_oid (+) AND usr.other_user_id = pr2.principal_oid (+) AND usr.other_user_id = pr3.principal_oid (+) AND 1 = pr1.object_oid (+) AND 2 = pr2.object_oid (+) AND 3 = pr3.object_oid (+) ~ select property_name, property_value, property_type from SMP_VDI_TARGET_PROPERTIES where object_id = ? and object_type = ? P delete from SMP_VDI_TARGET_PROPERTIES where object_id = ? AND object_type = ?  insert into SMP_VDI_TARGET_PROPERTIES (object_id, object_type, property_name, property_value, property_type) values (?, ?, ?, ?, ?) 8 BEGIN SMP_VDI.checkAndUpdateVersion(?, ?, ?, ?, ?);END;(Ljava/lang/String;)Vappend,(Ljava/lang/String;)Ljava/lang/StringBuffer;toString()Ljava/lang/String; ,-./0/1/2/3/4/5/6/7/8/9/:/;<=/;>?/;@A/;BC/D/;EF/;GH/;IJ/;KLMN*O3PMNjYYY       Y    Y    Y     Y     Y    ! "Y   # $Y   % &Y   ' (Y   )   * +O2 7 8;EAbEIMRUXZ<QR