OraFAQ Forum: Security » Oracle Auditing DBA_STMT_AUDIT_OPTS where user

Home » RDBMS Server » Security » Oracle Auditing DBA_STMT_AUDIT_OPTS where user_name is null (11.2.0.2.0 RHEL 6 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Auditing DBA_STMT_AUDIT_OPTS where user_name is null [message #574220]

Tue, 08 January 2013 02:41

preet_kumar
Messages: 204
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

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

preet_kumar
Messages: 204
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.

Report message to a moderator

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

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I am expecting from experienced asker a correct question.

Regards
Michel

Report message to a moderator

Previous Topic:	Password file authentication
Next Topic:	Remote connection using SYS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 07 22:45:55 CST 2026