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: 25578
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: 65150
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use a DDL trigger on CREATE (USER).

Previous Topic: Data Archiving n Purging
Next Topic: How to know a package is being called
Goto Forum:

Current Time: Mon Aug 21 16:48:29 CDT 2017

Total time taken to generate the page: 0.05275 seconds