GrantRevokePrivilegesToFromYourself: Grant to yourself

DenisJCilliers

I get this error when running Schema Compare in a Azure Pipeline

Schema Compare for Oracle version:6.0.23.1366: activated, serial number: 389-739-884494-CF6E

Schema Compare for Oracle Command Line - Product version: 6.0.23.1366

Reading dependency information

Registering database one

Registering database two

Comparing databases

Calculating dependencies

Finding issues with deployment

Issue:       GrantRevokePrivilegesToFromYourself: Grant to yourself

Resolutions: Skip

Resolution:  Skip

             Difference that may not be properly deployed will be skipped

Any Ideas on what to do ? as I cant seem to find anything in the documentation about this error

Jon_Kirkwood

Hi @DenisJCilliers

 Thank you for reaching out on the Redgate forums, and sorry to hear about your issues with Schema Compare for Oracle.

I note that you are on an older version of Schema Compare. To check if this issue has been resolved in a subsequent patch release, are you able to update your pipeline to use the current version of Schema Compare. The current version is V6.3.0 and depending on your usage may be accessed here:

https://hub.docker.com/r/redgate/schema-compare-for-oracle (tag - 'latest' or '6.3.0')

https://download.red-gate.com/checkforupdates/SchemaCompareforOracle/SchemaCompareforOracle_6.3.0.2028.exe

If you are able to run the latest version of Schema Compare and confirm if this error continues to appear.

 

This issue appears when a non-system user is attempting to grant or revoke privileges and is generated by Oracle and passed through our software.

Are you able to verify if the user running the pipeline does have appropriate privileges for the actions to be run by Schema Compare. https://docs.oracle.com/en/error-help/db/ora-01749/