-
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
-
Refer to DBA Handbook
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|