CCAPP Unauth AppUser SQLs
From:
2013/01/15 04:00:00
To:
2013/01/16 04:00:00
Linux64-11g
ORA11 on centos64
SesKeyStartUsernameProgramMachineIPCount
SQL StartCommandSQL Text
0016992013/01/15 17:41:12CCAPPsqlplus@centos64 (TNS V1-V3)centos64local10
2013/01/15 17:41:12SELECTSELECT USER FROM DUAL
2013/01/15 17:41:12INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus@centos64 (TNS V1-V3)',ACTION='',CLIENT=''--
2013/01/15 17:41:12PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:41:12SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
2013/01/15 17:41:12SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:41:13PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:41:13INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:41:13SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:41:16ERRORselect * from salariews
2013/01/15 17:41:23SELECTselect * from cards
Solaris-10g
ORA10 on steel
SesKeyStartUsernameProgramMachineIPCount
SQL StartCommandSQL Text
0008802013/01/15 17:44:11CCAPPsqlplus@steel (TNS V1-V3)steellocal9
2013/01/15 17:44:12SELECTSELECT USER FROM DUAL
2013/01/15 17:44:12INTERNAL--DBMS_APPLICATION_INFO: MODULE='sqlplus@steel (TNS V1-V3)',ACTION='',CLIENT=''--
2013/01/15 17:44:12PL/SQL EXECUTEBEGIN DBMS_OUTPUT.DISABLE; END;
2013/01/15 17:44:12SELECTSELECT ATTRIBUTE,SCOPE,NUMERIC_VALUE,CHAR_VALUE,DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (UPPER(USER) LIKE USERID)
2013/01/15 17:44:12SELECTSELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE   (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND   ((UPPER(USER) LIKE USERID) OR (USERID = 'PUBLIC')) AND   (UPPER(ATTRIBUTE) = 'ROLES')
2013/01/15 17:44:12PL/SQL EXECUTEBEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1,NULL); END;
2013/01/15 17:44:12INTERNAL--DBMS_APPLICATION_INFO: MODULE='SQL*Plus',ACTION='',CLIENT=''--
2013/01/15 17:44:12SELECTSELECT DECODE('A','A','1','2') FROM DUAL
2013/01/15 17:44:16SELECTselect * from cards