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?

Report message to a moderator

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;

Report message to a moderator

Previous Topic: How to use Password file
Next Topic: oracle security/reliable
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 09 09:32:45 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.