I face with this error on Oracle19c database. My user has sysdba and also dba grant with create any trigger privilege.
Complete message is:
SQL> create or replace trigger xxxx
create or replace trigger xxxx
ERROR at line 1:
ORA-01031: insufficient privileges
This is an expected behavior.
In 12.2 , direct grant of “administer database trigger” is needed for the trigger owner.
Grant “administer database trigger” privilege to your user directly.The operation will be succeeds.
SQL>grant administer database trigger to myuser;
Bir Cevap Yazın