OraFAQ Forum: Security » auditing of the db

Home » RDBMS Server » Security » auditing of the db

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

auditing of the db [message #59700]

Wed, 17 December 2003 05:44

jinga
Messages: 116
Registered: January 2003

Senior Member

I would like to write triggers to audit the tables. I am sure auditing all tables will give a performance problem. So it is wise to select only certain tables for auditing..

We need to capture the primary keys of the table being audited. so that later the row that is audited can be retrieved and displayed to the user.

Any input on the design will be appreciated

Anu

Report message to a moderator

Re: auditing of the db [message #59703 is a reply to message #59700]

Wed, 17 December 2003 08:49

Thiru
Messages: 1089
Registered: May 2002

Senior Member

Ananthi,
did you have a look at 9i's workspace manager(table versioning) and Fine grained auditing(dbms_fga) also ?

-Thiru

Report message to a moderator

Re: auditing of the db [message #59725 is a reply to message #59703]

Thu, 18 December 2003 08:56

jinga
Messages: 116
Registered: January 2003

Senior Member

I read about DBMS_FGA.It is just for auditing the select statements. Only in 10i, they will have auditing for DML also. So i think it is better to write the triggers.

Report message to a moderator

Re: auditing of the db [message #59727 is a reply to message #59703]

Thu, 18 December 2003 08:58

jinga
Messages: 116
Registered: January 2003

Senior Member

I read about DBMS_FGA.It is just for auditing the select statements. Only in 10i, they will have auditing for DML also. So i think it is better to write the triggers.

Report message to a moderator

Previous Topic:	connect/password question
Next Topic:	URGENT!!!! SYS PASSWORD AND 9i!!!

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 24 07:27:49 CST 2025