Database Administration (MOSC)

MOSC Banner

schema trigger is not working on RAC database

edited May 4, 2014 12:00PM in Database Administration (MOSC) 9 commentsAnswered

hello everyone..

I have test database 11g and production database RAC 10g (we didn't upgrade it yet..)

I  created a schema trigger to grant some privileges after create..it is working successfully on test database but not on the RAc...I keep getting the error..table or view doesn't exist..

this is my trigger:

CREATE OR REPLACE TRIGGER EPPIX.JAWBILLING_GRANTS

AFTER CREATE

ON EPPIX.SCHEMA

declare

v_job number;

v_todo varchar2(200);

begin

  if ora_sysevent = 'CREATE' and ora_dict_obj_type = 'TABLE'  then

     v_todo:='execute immediate ''grant select, insert, update, delete on '||ora_dict_obj_name||' to jawbilling'';';

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