Home » RDBMS Server » Security » To active auditing and check (9i)
To active auditing and check [message #323646] Thu, 29 May 2008 02:20 Go to next message
Messages: 11
Registered: May 2008
Junior Member
Dear Friends,
I want to know as a dba who has access a particular table last , can you please give me the steps...
Thanks and Regards...
Re: To active auditing and check [message #323660 is a reply to message #323646] Thu, 29 May 2008 03:00 Go to previous messageGo to next message
Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Re: To active auditing and check [message #335986 is a reply to message #323660] Thu, 24 July 2008 05:40 Go to previous message
Messages: 742
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Audit can be set by 3 parameters:

- audit_file_dest='Location_of_adump_directory'
- audit_sys_operations=TRUE/FALSE
- audit_trail=None/DB/OS

Only value set by DB, the data will create corresponding to your audit statement. You can retrieve them from sys.aud$ table.

[Updated on: Thu, 24 July 2008 05:41]

Report message to a moderator

Previous Topic: OS authentication
Next Topic: dbms_fga and join syntax
Goto Forum:

Current Time: Sun Mar 26 03:32:40 CDT 2023