What Oracle roles/privileges do I need to create a trigger on a table in another schema?
Doesn't cover the 'In another schema"
Gary
2009-11-17 05:19:29
+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
2009-11-17 05:19:06