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.

Symptoms

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.

Changes

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

Cause

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
Symptoms
Changes
Cause
Solution
References


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