Hi Dba's ::
I want to have my database audited. I guess I need to turn on Auditing.. How do I that.. Steps and etc.., Please give all the related links and any web sites.. Thx
Printable View
Hi Dba's ::
I want to have my database audited. I guess I need to turn on Auditing.. How do I that.. Steps and etc.., Please give all the related links and any web sites.. Thx
You can use the Oracle DBA Handbook which goes into detail about auditing. Also, you should do a search on the archives in this site (ie: search forums). Most likely the subject has been discussed previously.
- Magnus
Audit schema object
AUDIT object_privilege ON schema.object_name
[BY SESSION [WHENEVER [NOT SUCESSFULL]
[BY ACCESS [WHENEVER [NOT SUCESSFULL]
eg : audit select on scott.emp by access;
audit sql statements
eg : audit select table whenever not sucessfull