Home » RDBMS Server » Security » Audit in Oracle
Audit in Oracle [message #179895] Thu, 29 June 2006 04:20 Go to next message
weyd_ii
Messages: 5
Registered: October 2005
Location: Russia
Junior Member
Hello, everybody!
I have a problem in auditing some user actions in Oracle.
For example, how could I audit using of GRANT ANY PRIVILEGE privilege? I asked it for auditing:
AUDIT GRANT ANY PRIVILEGE BY ACCESS

The following record has been appeared in the DBA_PRIV_AUDIT_OPTS view.
But when I actually use this privilege nothing is audited. And I'm sure that I really use it because when I revoke this privilege from my user I can't grant any privilege.

So, does anybody know what did I do wrong?
Re: Audit in Oracle [message #179954 is a reply to message #179895] Thu, 29 June 2006 06:47 Go to previous messageGo to next message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
Set audit_trail=DB in your SPFILE/ INIT.ORA file.
Re: Audit in Oracle [message #179968 is a reply to message #179954] Thu, 29 June 2006 08:17 Go to previous message
weyd_ii
Messages: 5
Registered: October 2005
Location: Russia
Junior Member
It is already set. AUDIT_TRAIL=DB
And another actions are audited. The problem is about this one.

If you're sure that it works try to get it in your Oracle and then show me steps.
Previous Topic: who is the actual user ??
Next Topic: how to connect after creating passwd file
Goto Forum:
  


Current Time: Tue Nov 30 03:15:24 CST 2021