Home » SQL & PL/SQL » SQL & PL/SQL » Auditing DML actions on multiple databases
Auditing DML actions on multiple databases [message #335285] Mon, 21 July 2008 13:01 Go to next message
Messages: 161
Registered: February 2007
Senior Member
I am using Oracle 10g Database on Solaris .

I need to audit the complete DML statement issued on a table which exists in multiple schemas(same name with different data from other schemas) in multiple databases ie Consider the table ito be audited is "TAB_A" . This table exists in multiple schemas "USER_A", "USER_B" but as said before only the name remains the same but data is different so they are two different tables. Also there are many databases "DB_A" , "DB_B" which have that table .

There is a master database which collects information from all these databases through database links . Now this database has a table which gets updated with a username, schema name and database name once a new user is created on the databases DB_A and DB_B . So is there any way I can use this info and automate the auditing so that the DBMS_FGA.ADD_POLICY procedure gets fired when a new user say USER_C is created ? This will not involve any manual involvement in running DBMS_FGA.ADD_POLICY procedure for USER_C.TAB_A
Re: Auditing DML actions on multiple databases [message #335292 is a reply to message #335285] Mon, 21 July 2008 13:25 Go to previous messageGo to next message
Messages: 25352
Registered: January 2009
Location: SoCal
Senior Member
Please read & follow posting guidelines as stated in URL above

Yes, by implementing an AFTER INSERT trigger.
Re: Auditing DML actions on multiple databases [message #335293 is a reply to message #335285] Mon, 21 July 2008 14:02 Go to previous message
Michel Cadot
Messages: 64729
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use a DDL trigger on CREATE (USER).

Previous Topic: How to implement PHP sprintf in PL/SQL
Next Topic: commit based on Group name
Goto Forum:

Current Time: Thu Apr 27 21:46:03 CDT 2017

Total time taken to generate the page: 0.06987 seconds