When I try to create a trigger in schema A for a table located in schema B, I get an ora error : insufficient privileges.
What privileges do I need?
views:
830answers:
1
+4
A:
If you are creating the trigger in your schema, you'll need the CREATE TRIGGER privilege. In order to create the trigger in somebody else's schema, you'll need the CREATE ANY TRIGGER privilege.
This resource does a very good job of explaining the requirements, and contains more information about triggers (syntax, enabling, disabling, etc).
Todd
2009-01-02 02:37:20
You can create a trigger in schema X that fires on an action on a table in schema Y. I think this requires CREATE ANY TRIGGER which is very powerful. Suggest DBA do a create trigger user_x.trigger_name before insert on user_y.tab_name begin ... end;rather than grant CREATE ANY TRIGGER to user_x
Gary
2009-01-04 23:34:56