Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database diff: WHY: You must own the objects or have select_catalog_role?

Dezsoe KadosMar 27 2020 — edited Jul 23 2021

When trying to do a database diff following is shown on the diff result screen:

<some package body name> using <some connection name>  connection.

Unable to compare objects.

Ensure that you have the required permissions.

You must own the objects or have select_catalog_role.

The starnge thing is that the  user IS the owner of the compared packages (on both involved connections)

Even tried to grant the "select_catalog_role" to the users but the result is the same.

Btw the package spec comparison of that same package is showing the correct differences.

Any ideas

sqldeveloper 19.4/21.2  (tested on DB versions 12.1 + 19.3)

Message was edited by: Dezsoe Kados

Comments
Post Details
Added on Mar 27 2020
10 comments
1,523 views