My Oracle Support Banner

Differences of Data Models in Users And Role Permissions With Compare and Merge (Doc ID 2625347.1)

Last updated on JUNE 24, 2021

Applies to:

Oracle SQL Developer Data Modeler - Version 19.1 to 19.2
Information in this document applies to any platform.


This symptom is observed Only on Data Models created with "Oracle Database 11g" as RDBMS Site.

1. Create a Data Model with Users and Roles.   

2. Create a copy of the model using "Save As" option. 

3. Go to menu Tools-->Compare/Merge Models. Select the model that was saved using "Save As" option and click 'Ok". 

4. The Compare/Merge wizard shows differences with "Saved As" Model under Users and Roles section. It is observed in the below image, Relational_1(V3) which is copied version from Relational_1(V2) has missing schema "Users" and its associated "Roles" in the "Saved As/Copied(V3)" data model during compare and merge activity.

NOTE: The example(s) provided are for demonstration purposes only and represents fictitious data. Any similarity to actual data, web sites and / or persons, living or dead, is purely coincidental and not intended in any manner.


 Using or creating a model with Oracle Database 11g as RDBMS site with 19C Data Modeler.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.