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
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.
Previous Topic: User-specific trigger auditing
Next Topic: How to connect ws services to the oracle db without password?
Goto Forum:
  


Current Time: Fri Mar 29 04:47:23 CDT 2024