1

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?

Michael Myers
  • 188,989
  • 46
  • 291
  • 292
Jeff
  • 8,020
  • 34
  • 99
  • 157

1 Answers1

3
GRANT CREATE ANY TRIGGER ON b TO a

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

Quassnoi
  • 413,100
  • 91
  • 616
  • 614