Home » RDBMS Server » Security » Audit on Single user ??
Audit on Single user ?? [message #56121] Thu, 06 March 2003 22:22 Go to next message
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 Go to previous message
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;
Previous Topic: grant
Next Topic: Security concern: connect internal
Goto Forum:
  


Current Time: Sun May 22 13:19:48 CDT 2022