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 best solutions below

0
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.