Home » RDBMS Server » Security » Not able to check the SQL statements used by user- need help
Not able to check the SQL statements used by user- need help [message #160155] Thu, 23 February 2006 10:14 Go to next message
pzlj6x
Messages: 107
Registered: May 2005
Location: Louisville
Senior Member

I have oracle 10g installed.
I set the the audit_trail to 'DB'.

I am able to see the user logging information. However I would to see the SQL statements that were used by users.

I check the view dba_audit_trail and find the sql_text field is empty.
Also I check the sys.aud$ view, same result - sqltext is empty.

Is there something should be setting in initialization parameter?

Advise please
Thanks

Report message to a moderator

Re: Not able to check the SQL statements used by user- need help [message #174353 is a reply to message #160155] Sun, 28 May 2006 07:32 Go to previous message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
You may need 'audit all'.

If you use enterprise manager you can see each users statements.

Report message to a moderator

Previous Topic: User-specific trigger auditing
Next Topic: How to connect ws services to the oracle db without password?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 16 16:11:32 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.