I face with this error on Oracle19c database. My user has sysdba and also dba grant with create any trigger privilege.

Complete message is:

conn myuser/mypass@DB_SID

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;