views:

52

answers:

2

What Oracle roles/privileges do I need to create a trigger on a table in another schema?

A: 
GRANT CREATE TRIGGER TO user_class;
wallyk
Doesn't cover the 'In another schema"
Gary
+1  A: 

"in another schema?"

CREATE ANY TRIGGER. However, like any ANY privilege, it is VERY dangerous so a DBA is unlikely to give it to you.

The DBA could create that trigger for you or maybe give you the password to that schema to create the trigger there.

Gary