Home » Other » Client Tools » Audit logging issue with SQL Developer (Oracle 11g R2)
Audit logging issue with SQL Developer [message #599132] Tue, 22 October 2013 07:09 Go to next message
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 #599136 is a reply to message #599132] Tue, 22 October 2013 08:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

There is no issue, this is how SQL Developer works.

Re: Audit logging issue with SQL Developer [message #599273 is a reply to message #599136] Wed, 23 October 2013 07:54 Go to previous messageGo to next message
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
icon2.gif  Re: Audit logging issue with SQL Developer [message #599278 is a reply to message #599273] Wed, 23 October 2013 08:13 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Maybe those you can find in dba_obj_audit_opts and dba_priv_audit_opts.

Re: Audit logging issue with SQL Developer [message #599289 is a reply to message #599278] Wed, 23 October 2013 08:42 Go to previous message
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
Previous Topic: ERD for a schema using sql navigator
Next Topic: ora-01034 for users other than oracle
Goto Forum:
  


Current Time: Thu Mar 28 06:43:01 CDT 2024