Home » RDBMS Server » Security » audit user activities in database.
audit user activities in database. [message #56474] Wed, 02 April 2003 13:14 Go to next message
Anthony pena
Messages: 12
Registered: July 2002
Junior Member
i would know if i could see in an oracle database, the user's activities details in the database, i know that exists a dic table (user_audit_trail), where i can see the action that has been done by an user, but the problem is, that i wanna know more details about the user's actions(sqlstatements).
If somebody know how to do it?, please let me know
Re: audit user activities in database. [message #56477 is a reply to message #56474] Wed, 02 April 2003 15:55 Go to previous message
Anand
Messages: 161
Registered: August 1999
Senior Member
This is possible through a feature in Oracle called FGA ( Fine Grained Auditing ) which would actually find out what value was manipulated to what. But, this needs a more advanced setup.

Please check metalink/other resources for more details on FGA.
Previous Topic: enabling auditing!
Next Topic: Problem defining role
Goto Forum:
  


Current Time: Thu Mar 28 06:43:54 CDT 2024