auditing problem [message #535890] |
Sat, 17 December 2011 03:42 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/e77f0a4be52ece672d91ceb99ecdf345?s=64&d=mm&r=g) |
hemant_khandare
Messages: 72 Registered: November 2011
|
Member |
|
|
i enabled auditing by setting
audit_trail=db,extended in spfile,and restart the database and after that i issued command to audit as below :
audit select on emp by access;
but how to see audit log information(ie from which table),i checked dba_audit_trail but it doesnot have any record.
Kindly suggest.
|
|
|
Re: auditing problem [message #535913 is a reply to message #535890] |
Sat, 17 December 2011 08:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8937 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Are you sure you have enabled the audit trail? You need to cheeck this:
select value from v$parameter where name='audit_trail';
and have you actually enabled the auditing:
select owner,object_name from,sel DBA_OBJ_AUDIT_OPTS;
and lastly, have you selected from the table yet?
[update: one other possibility, are you testing this as SYS? If so, don't! Test it as some other user. To audit SYS, you need to set AUDIT_SYS_OPERATIONS.]
[Updated on: Sat, 17 December 2011 08:16] Report message to a moderator
|
|
|
|
|
|