What are the challenges you face when working across database platforms? Take the survey
Options

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.
Tagged:

Answers

Sign In or Register to comment.