Audit on Single user ?? [message #56121] |
Thu, 06 March 2003 22:22 |
SureshB
Messages: 7 Registered: June 2002
|
Junior Member |
|
|
Hi All,
My production database is under Oracle8i/NT.
Can any one tell me the syntax of audit trail for a particular user on scott.emp. This is a bit urgent.
Thanks,
Suresh.
|
|
|
Re: Audit on Single user ?? [message #56165 is a reply to message #56121] |
Mon, 10 March 2003 14: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;
|
|
|