Database Security Products (MOSC)

MOSC Banner

Oracle 11g ON-EVENT (CREATE TABLE) trigger sometimes does not fire

edited Jun 17, 2016 5:11AM in Database Security Products (MOSC) 10 commentsAnswered

I have the following trigger on the DSMITH schema. 

I have noticed on numerous occasions that when another user (ie. JDOE) creates a table for DSMITH, the trigger does not fire (the grants to the new table are not being given to the appropriate roles).

What would cause the grants to not have been created?  Is there a better way to do this? 

We have numerous roles that need to be given their appropriate grants when new tables are created.

Thanks!

CREATE OR REPLACE TRIGGER "DSMITH".CREATE_DSMITH_GRANTS AFTER
CREATE ON "DSMITH".SCHEMA DECLARE
l_str1 VARCHAR2(255);
l_str2

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center