| Audit logging issue with SQL Developer [message #599132] |
Tue, 22 October 2013 07:09  |
Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi
|
Senior Member |
|
|
Hi All,
I was experimenting with audit logging don't know what went wrong. When I log on using SQL developer I see about 100 logging entries in AUD$ as below. But if I log on using SQL Plus with same user no such audit logging happen.
Please help me to find out this issue.
Below audit log entries are being generated.
select 1 from dba_xml_schemas where 1=2
select 1 from dba_xml_schemas where 1=2
/*+ NO_SQL_TRANSLATION */ select 1 from sys.obj$ where 1=0
select 1 from dba_editions where 1=2
select 1 from dba_editions where 1=2
select 1 from dba_editions where 1=2
select 1 from dba_editions where 1=2
select 1 from dba_queue_tables where 1=2
select 1 from dba_queue_tables where 1=2
select 1 from dba_queue_tables where 1=2
select 1 from dba_queue_tables where 1=2
select 1 from dba_queue_tables where 1=2
select 1 from dba_queue_tables where 1=2
select 1 from dba_queue_tables where 1=2
select 1 from dba_queue_tables where 1=2
select 1 from dba_queue_tables where 1=2
select 1 from dba_queues where 1=2
select 1 from dba_queues where 1=2
select 1 from dba_queues where 1=2
select 1 from dba_queues where 1=2
select 1 from dba_queues where 1=2
select 1 from dba_queues where 1=2
select 1 from sys.dba_recyclebin where 1=2
select 1 from sys.dba_recyclebin where 1=2
select 1 from sys.dba_recyclebin where 1=2
select 1 from sys.dba_recyclebin where 1=2
select 1 from sys.dba_recyclebin where 1=2
select 1 from sys.dba_recyclebin where 1=2
select 1 from sys.dba_recyclebin where 1=2
select 1 from sys.dba_recyclebin where 1=2
select 1 from sys.dba_recyclebin where 1=2
select 1 from sys.external_tab$ where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_mviews where 1=2
select 1 from dba_objects where 1=2
select 1 from dba_objects where 1=2
select 1 from dba_objects where 1=2
select 1 from dba_objects where 1=2
select 1 from dba_objects where 1=2
select 1 from dba_objects where 1=2
select 1 from dba_objects where 1=2
select 1 from dba_objects where 1=2
select 1 from dba_objects where 1=2
select 1 from dba_objects where 1=2
select 1 from dba_objects where 1=2
select 1 from dba_objects where 1=2
select 1 from dba_tab_privs where 1=2
select 1 from dba_tab_privs where 1=2
select 1 from dba_tab_privs where 1=2
select 1 from dba_tab_privs where 1=2
select 1 from dba_tab_privs where 1=2
select 1 from dba_tab_privs where 1=2
select 1 from dba_tab_privs where 1=2
select 1 from dba_tab_privs where 1=2
select 1 from dba_tab_privs where 1=2
select 1 from dba_tab_privs where 1=2
select 1 from dba_tab_privs where 1=2
select 1 from dba_db_links where 1=2
select 1 from dba_db_links where 1=2
select 1 from dba_db_links where 1=2
Thanks & Regards
Manoj
|
|
|
|
|
|
| Re: Audit logging issue with SQL Developer [message #599273 is a reply to message #599136] |
Wed, 23 October 2013 07:54  |
Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi
|
Senior Member |
|
|
Hi Michel,
I removed all audit logging existed in DBA_STMT_AUDIT_OPTS view by using NOAUDIT. But still some selects are being logged in AUD$. Can you please help me to investigate which audit logging is still enabled which is forcing these queries to be logged.
SELECT * FROM DBA_AUDIT_OBJECT ;
SELECT A.NTIMESTAMP#, A.SQLTEXT, A.*
FROM AUD$ A
where lower(A.spare1) = lower('manoj')
ORDER BY A.NTIMESTAMP# DESC
Thanks & Regards
Manoj
|
|
|
|
|
|
| Re: Audit logging issue with SQL Developer [message #599289 is a reply to message #599278] |
Wed, 23 October 2013 08:42 |
Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi
|
Senior Member |
|
|
Hi Michel,
I found only one entry
SELECT * FROM dba_obj_audit_opts ;
OWNER OBJECT_NAME OBJECT_TYPE ALT AUD COM DEL GRA IND INS LOC REN SEL UPD REF EXE CRE REA WRI FBK
SYS AUD$ TABLE A/A A/A A/A A/A A/A A/A A/A A/A A/A A/A A/A -/- -/- -/- -/- -/- A/A
Thanks & Regards
Manoj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
