:Re: DB Trigger to control PK change
I am trying to do something similar. I want to trap when new tables and procedures
are created so I can issue grants and synonyms. I found in the manual triggers at the
schema level but I haven't been able to make them work.
From the manual
CREATE
Trigger to control PK change
As opposed to using auditing? What version of Oracle?
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL
John,
How about:
CREATE OR REPLACE TRIGGER On_DDL
after CREATE
ON your.schema
BEGIN
.
HTH
Mark
===
Mark Leith | T: +44 (0)1905 330 281
Sales Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL
As opposed to using auditing? What version of Oracle?
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday,
I am not sure there is a trigger to do that Ramon.
Why not use the audit option to track changes.
John
-Original Message-
[EMAIL PROTECTED]
Sent: 03 April 2002 22:33
To: Multiple recipients of list ORACLE-L
Hi List,
I want to create a trigger that insert into a table anytime a user
I am trying to do something similar. I want to trap when new tables and procedures
are created so I can issue grants and synonyms. I found in the manual triggers at the
schema level but I haven't been able to make them work.
From the manual
CREATE OR REPLACE TRIGGER On_DDL
after DDL
ON