Home » RDBMS Server » Security » Audit sql statement
Audit sql statement [message #57857] Fri, 11 July 2003 06:57 Go to next message
Suresh
Messages: 189
Registered: December 1998
Senior Member
One of my database is under AUDIT. As of now I'm getting the info such as update,delete issued by enduser.
I want to get the sql update statement issued by the end user ? If possible, can anyone tell me how to do?
Re: Audit sql statement [message #57864 is a reply to message #57857] Fri, 11 July 2003 10:48 Go to previous message
Navtej
Messages: 19
Registered: July 2003
Junior Member
select username, priv_used, ses_actions from dba_audit_object;
select action, action_name, username from dba_audit_trail ;
select * from dba_stmt_audit_opts;
Previous Topic: How to use Password file
Next Topic: oracle security/reliable
Goto Forum:
  


Current Time: Sun Sep 26 22:18:45 CDT 2021