schema trigger is not working on RAC database
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'';';