Home » SQL & PL/SQL » SQL & PL/SQL » Schema level Trigger on DML operations
Schema level Trigger on DML operations [message #285384] Tue, 04 December 2007 06:19 Go to next message
thisisnatesh
Messages: 92
Registered: March 2007
Member
Can i create a schema level trigger
which fires on dml operations
on any table of the schema?

please help me in this regard

Thanks in Advance

Natesh
Re: Schema level Trigger on DML operations [message #285386 is a reply to message #285384] Tue, 04 December 2007 06:26 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Are you looking for an AUDIT mechanism?

MHE
Re: Schema level Trigger on DML operations [message #285387 is a reply to message #285386] Tue, 04 December 2007 06:27 Go to previous messageGo to next message
thisisnatesh
Messages: 92
Registered: March 2007
Member
yes
Re: Schema level Trigger on DML operations [message #285389 is a reply to message #285387] Tue, 04 December 2007 06:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For a direct answer, no there is no such thing but you can easely create a script that automatically generates the trigger for any table.

Now, why don't you use Oracle audit?

Regards
Michel

[Updated on: Tue, 04 December 2007 06:54]

Report message to a moderator

Re: Schema level Trigger on DML operations [message #285392 is a reply to message #285387] Tue, 04 December 2007 06:36 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I think you'll find this link very interesting then. It explains Oracle's built-in auditing capabilities. The OracleŽ Database Security Guide and OracleŽ Database Administrator's Guide will explain more about it.

You could go for a trigger implementation but it is my opinion that this isn't as robust as the first option I mentioned.

[edit]Michel agrees: the trigger way seems less favorite. Very Happy

MHE

[Updated on: Tue, 04 December 2007 06:37]

Report message to a moderator

Previous Topic: how can i get missing dates
Next Topic: Urgent Help for 4 Shift Attendance procedure.
Goto Forum:
  


Current Time: Sat Dec 10 12:55:20 CST 2016

Total time taken to generate the page: 0.08676 seconds