Home » RDBMS Server » Security » auditing of the db
auditing of the db [message #59700] Wed, 17 December 2003 05:44 Go to next message
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
Re: auditing of the db [message #59703 is a reply to message #59700] Wed, 17 December 2003 08:49 Go to previous messageGo to next message
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
Re: auditing of the db [message #59725 is a reply to message #59703] Thu, 18 December 2003 08:56 Go to previous messageGo to next message
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.
Re: auditing of the db [message #59727 is a reply to message #59703] Thu, 18 December 2003 08:58 Go to previous message
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.
Previous Topic: connect/password question
Next Topic: URGENT!!!! SYS PASSWORD AND 9i!!!
Goto Forum:
  


Current Time: Mon Nov 23 16:49:14 CST 2020