Oracle Trigger Permissions

2.2k views Asked by At

I want to create a trigger owned by user A for a table that is owned by user B. What permissions must I set on B.table to avoid an ORA-01031: insufficient privileges error?

1

There are 1 answers

0
Quassnoi On BEST ANSWER
GRANT CREATE ANY TRIGGER ON b TO a

There is no way to grant a permission to create a trigger on a certain table.