Skip to Main Content

SQL Developer Data Modeler

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!

Importing ROLES from the database

LuboshFeb 16 2024

I found strange behavior when importing ROLES from a database into a model.

I import everything, including all ROLES. Here is a list of them with the designation of the problematic section:

These red-marked ROLES (AKROS2, AKROS3) were also imported to me, even though they were not in the original list (see above) at all:

They were not listed because they are not even in the database:

AKROS2, AKROS3 are in the database only as USERS.

When I do a database comparison I get this strange result:

I wondered what happens if I don't import USERS.

Without USERS, there is much more inequality in other roles by comparison:

What am I doing wrong?

Comments
Post Details
Added on Feb 16 2024
1 comment
119 views