| audit_trail parameter setting [message #56195] |
Wed, 12 March 2003 01:31  |
jhansi
Messages: 5
Registered: February 2003
|
Junior Member |
|
|
hi
I want to audit one of the users activity. How do i set the AUDIT_TRAIL parameter to DB. I tried setting that in init[[db_name]].ora file. But the there is a comment in the file that setting this to false will enable auditing.
After setting the parameter how do i activate the auditing
thanks in advance
Jhansi
|
|
|
|
| Re: audit_trail parameter setting [message #56207 is a reply to message #56195] |
Wed, 12 March 2003 13:21  |
Michel Bartov
Messages: 35
Registered: February 2003
|
Member |
|
|
I just posted an integrated set of GUI tools to administer the Oracle database (it is free).
One of the functions is ‘Manage Database Auditing, under ‘Security’ that allows you to audit a specific user by statement or object and view all actions performed by the user.
You may need same help to get started, so feel free to contact me (michelbartov@go.com). The link is http://www.barsoft.net/
You may also try this command: AUDIT ALL BY SCOTT BY SESSION; or AUDIT INSERT, UPDATE, DELETE ON SCOTT.EMP BY ACCESS;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
