OraFAQ Forum: Security » Audit sql statement

Home » RDBMS Server » Security » Audit sql statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Audit sql statement [message #57857]

Fri, 11 July 2003 06:57

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 05:09:46 CST 2025