How can we help you today? How can we help you today?

Insufficient privileges error when creating trigger redgate.check_locks

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.
Eric
0

Comments

1 comment

Sort by
  • Eddie D
    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
    1. CREATE USER
    2. CREATE ROLE
    3. GRANT ANY PRIVILEGE
    4. CREATE ANY TABLE
    5. CREATE ANY PROCEDURE

    Did your user have the database privileges listed above?

    Has any other user encountered the reported error?

    Many Thanks
    Eddie
    Eddie D
    0

Add comment

Please sign in to leave a comment.