You are currently browsing the tag archive for the ‘trigger ORA-01031’ tag.

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
begin
null;
end;
create or replace trigger xxxx
*
ERROR at line 1:
ORA-01031: insufficient privileges

Read the rest of this entry »