CODEWITHSUNDEEP
oracle-databasepermissionstriggersprivilegesora-01031
Jeff
Jeff

Reputation: 8148

Oracle Trigger Permissions

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?

Upvotes: 1

Views: 2216

Answers (1)

Quassnoi
Quassnoi

Reputation: 425823

GRANT CREATE ANY TRIGGER ON b TO a

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

Upvotes: 3

Related Questions