Tried to disable and enable a trigger (which is own by another user) by a procedure but we are getting error "ORA-01031: insufficient privileges" event though calling user(
Solution:
I
Just as
CREATE OR REPLACE PROCEDURE test
AUTHID CURRENT_USER ----set Invoker Rights not definer rights
isbegin
EXECUTE IMMEDIATE 'alter trigger tri_name disable';
.......
........
EXECUTE IMMEDIATE 'alter trigger tri_name enable';
end ;
No comments:
Post a Comment