: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
PROTECTED]]
Sent: Wednesday, April 03, 2002 3:33 PM
To: Multiple recipients of list ORACLE-L
Subject: DB Trigger to control PK change
Hi List,
I want to create a trigger that insert into a table anytime a
user change or compile a package doesn't matter who create it
or compile
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
Hi List,
I want to create a trigger that insert into a table anytime a user change or compile a
package doesn't matter who create it or compile it.
Is there a trigger at DB level, like the on logon, that I can create to keep this kind
of control.
I did some FM but couldn't find nothing.
, April 03, 2002 3:33 PM
To: Multiple recipients of list ORACLE-L
Subject: DB Trigger to control PK change
Hi List,
I want to create a trigger that insert into a table anytime a
user change or compile a package doesn't matter who create it
or compile it.
Is there a trigger at DB level
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