| 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
|
|
|
|
| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
