Home » RDBMS Server » Security » Oracle Auditing DBA_STMT_AUDIT_OPTS where user_name is null (11.2.0.2.0 RHEL 6 )
Oracle Auditing DBA_STMT_AUDIT_OPTS where user_name is null [message #574220] Tue, 08 January 2013 02:41 Go to next message
preet_kumar
Messages: 152
Registered: March 2007
Senior Member
I have enabled Auditing but when i run the below given statement i get the output with count of 20 null username.I tried to run NOAUDIT ALL but still the same result.
Why does it show auditing for null username and how can i disable it.

select count(*) from DBA_STMT_AUDIT_OPTS where user_name is null;
20

[Updated on: Tue, 08 January 2013 02:47]

Report message to a moderator

Re: Oracle Auditing DBA_STMT_AUDIT_OPTS where user_name is null [message #574240 is a reply to message #574220] Tue, 08 January 2013 03:47 Go to previous messageGo to next message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you didn't restrict the audit to some users then user_name is null.

Once more do not just explain what you think it is, SHOW US.

Use SQL*Plus and copy and paste your session, the WHOLE session.
Show us ALL rows.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: Oracle Auditing DBA_STMT_AUDIT_OPTS where user_name is null [message #574284 is a reply to message #574240] Tue, 08 January 2013 09:36 Go to previous messageGo to next message
preet_kumar
Messages: 152
Registered: March 2007
Senior Member
Below SQL*Plus copy and paste result is count 20
SQL> select count(*) from DBA_STMT_AUDIT_OPTS where user_name is null;
20

I am expecting response from Experienced DBA's for my simple below given question
How to make the count 0 with single command
I have tried NOAUDIT ALL but did not work.
Re: Oracle Auditing DBA_STMT_AUDIT_OPTS where user_name is null [message #574289 is a reply to message #574284] Tue, 08 January 2013 10:43 Go to previous message
Michel Cadot
Messages: 57603
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I am expecting from experienced asker a correct question.

Regards
Michel
Previous Topic: Password file authentication
Next Topic: Remote connection using SYS
Goto Forum:
  


Current Time: Thu Apr 17 00:25:46 CDT 2014

Total time taken to generate the page: 0.11399 seconds