OraFAQ Forum: Security » audit user activities in database.

Home » RDBMS Server » Security » audit user activities in database.

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

audit user activities in database. [message #56474]

Wed, 02 April 2003 13:14

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

Report message to a moderator

Re: audit user activities in database. [message #56477 is a reply to message #56474]

Wed, 02 April 2003 15:55

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.

Report message to a moderator

Previous Topic:	enabling auditing!
Next Topic:	Problem defining role

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 29 17:03:17 CDT 2025