-
Quick response appreciated(Session Info)
Hello,
Please does anyone have an example of a code (trigger or proc) that can capture the session information for any table dropped or truncated in a particular Database schema? Or have an idea of the best way to go about doing that.
A quick response will be appreciated.
Thanks
phraim
-
Re: Quick response appreciated(Session Info)
Originally posted by phraim
capture the session information for any table dropped or truncated in a particular Database schema
For 'truncate table' auditing...
http://download-west.oracle.com/docs...udit.htm#13360
For examples..'drop' auditing
http://www.oracle-base.com/Articles/8i/Auditing.asp
HTH.
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
|