Home » RDBMS Server » Security » how to audit sql statment thr' audit /trigger in 8.1.7
how to audit sql statment thr' audit /trigger in 8.1.7 [message #51923] Fri, 21 June 2002 08:25 Go to next message
Kalyan
Messages: 16
Registered: October 2001
Junior Member
Hiya,

I want to trap all the sql statment issued to a schema.

The db version is 8.1.7

Please send a model script if possible.

Thanks
Re: how to audit sql statment thr' audit /trigger in 8.1.7 [message #51933 is a reply to message #51923] Fri, 21 June 2002 15:00 Go to previous message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
1. AUDIT_TRAIL = DB

2. AUDIT_FILE_DEST = $ORACLE_HOME/rdbms/audit

3. SVRMGR> select * from sys.aud$; no rows should be returned
SVRMGR> select * from dba_audit_trail; no rows should be returned

If these views do not exist continue with the following:

SVRMGR> connect internal <or as user SYS>
SVRMGR> @cataudit.sql

4. Shutdown and then restart the database.

5. Specify the Audit option to be used

SQL> connect system/manager
SQL> grant audit system to scott;
SQL> connect scott/tiger
SQL> audit session;
and to disable session auditing:
SQL> noaudit session;

Hope that helps,

clio_usa
OCP - DBA

Visit our web site [url=http://www.dbaclick.com/cgi-bin/ib3/ikonboard.cgi]Click Here

Previous Topic: Grant object privileges to a role on other schema objects
Next Topic: audit records generated for a user even after disabling audit for that particular user
Goto Forum:
  


Current Time: Thu Mar 28 11:06:50 CDT 2024