Home » RDBMS Server » Security » Why cant audit?
Why cant audit? [message #61269] Thu, 08 April 2004 19:41 Go to next message
nvtnow
Messages: 5
Registered: April 2004
Junior Member
although i enabled the parameter 'audit_trail' = DB but i still dont audit. does anyone know the reason why???
Re: Why cant audit? [message #61271 is a reply to message #61269] Thu, 08 April 2004 22:00 Go to previous message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

U can't audit by just setting the audit_trail parameter to some value, this setting describe that the audit information will be stored in DB i.e. in SYS.AUD$ table.

To enable auditing issue the appropriate commands with a user having proper priveleges, like :

AUDIT SESSION

AUDIT SELECT ON EMP BY SCOTT

AUDIT CREATE INDEX WHENEVER SUCCESSFULL

And after that to quit auditing use NOAUDIT.

Daljit Singh.
Previous Topic: Trouble with 'grant' procedure
Next Topic: Checking oracle encrypted oracle user password
Goto Forum:
  


Current Time: Tue Apr 20 04:19:26 CDT 2021