OraFAQ Forum: Security » To active auditing and check

Home » RDBMS Server » Security » To active auditing and check (9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

To active auditing and check [message #323646]

Thu, 29 May 2008 02:20

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...

Report message to a moderator

Re: To active auditing and check [message #323660 is a reply to message #323646]

Thu, 29 May 2008 03:00

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

AUDIT

Regards
Michel

Report message to a moderator

Re: To active auditing and check [message #335986 is a reply to message #323660]

Thu, 24 July 2008 05:40

trantuananh24hg
Messages: 744
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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 10:40:12 CDT 2024