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
amjadali
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: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
AUDIT

Regards
Michel
Re: To active auditing and check [message #335986 is a reply to message #323660] Thu, 24 July 2008 05:40 Go to previous message
trantuananh24hg
Messages: 668
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: TDE wallet creation and setup
Goto Forum:
  


Current Time: Sun Dec 04 04:23:54 CST 2016

Total time taken to generate the page: 0.06165 seconds