Insufficient privileges error when creating trigger redgate.check_locks

ehaugen · November 3, 2017 4:32PM

We recently migrated one of our database instances from Oracle 11g to 12c Enterprise Edition (12.2.0.1) and attempted to run the SCO 4.0.3.189 object locking script. However, the script failed on CREATE OR REPLACE TRIGGER redgate.check_locks with 'ORA-01031: insufficient privileges' even when running as SYS. The script ran fine on a different database instance running Oracle 11c. We resolved this by granting dba to the REDGATE user, signing on as REDGATE, running the create trigger script and then revoking dba from REDGATE. Has anyone else run into this and did you have a different way of resolving it? Thanks.

Eddie D · November 6, 2017 2:43PM

Hi, thank you for sharing your problem and resolution in regards to configuring the Object Locking feature of Source Control for Oracle on an Oracle 12c (12.2.0.1) database.

From the support calls received I am not aware of any problems. This help article explains the database privileges required:
https://documentation.red-gate.com/soco4/using-source-control-for-oracle/locking-objects/setting-up-object-locking

CREATE USER
CREATE ROLE
GRANT ANY PRIVILEGE
CREATE ANY TABLE
CREATE ANY PROCEDURE

Did your user have the database privileges listed above?

Has any other user encountered the reported error?

Many Thanks
Eddie

Insufficient privileges error when creating trigger redgate.check_locks

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk