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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Incoming Changes from Subversion: Foreign Key merged as Index proxy

Robert MackovikAug 7 2024

Hello,
I use Oracle Data Modeler standalone version 23.1.0.087.0806.
Me and my colleague were trying to test team collaboration using SVN.
SVN communication is working, we can see and process Incoming changes and Outgoing changes.
Currently we face one problem.

User1 created new table and new foreign key in existing model, and changes were commited to SVN repository.
When User2 merged Incoming Changes, new FK was merged as “Index proxy” into Physical model (12cR2). So the result was missing FK on the table + additional Index on the table, with the name of missing FK and no columns. Additional Outgoing changes were automatically generated to transfer this error to SVN repository.

We also tried to delete WC from local directory and check out the model from SVN repository to find out where the problem is. When we checked out, everything is fine, FK exists and no index proxy is present. So the problem is around Merge of Incoming changes in Modeler.

We did compare source (User1), middle (SVN) and target (User2) xml of the table.
Source xml is the same as middle xml. Here is FK definition:

<foreignKeys>
<ForeignKey class="oracle.dbtools.crest.model.design.storage.oracle.v10g.FKProxyOraclev10g" name="fk_new_table_robert3_new_table_robert2" id="0058CF87-F1BA-C07D-1233-EBBF5AEFD58B">
<createdBy>User1</createdBy>
<createdTime>2024-08-07 07:54:46 UTC</createdTime>
<ownerDesignName>ModelTest</ownerDesignName>
</ForeignKey>
</foreignKeys>

Target xml has no foreignKeys tag, but it has this section:

<indexProxies>
<IndexProxy class="oracle.dbtools.crest.model.design.storage.oracle.v10g.IndexProxyOraclev10g" name="fk_new_table_robert3_new_table_robert2" id="0058CF87-F1BA-C07D-1233-EBBF5AEFD58B">
<createdBy>User2</createdBy>
<createdTime>2024-08-07 07:57:01 UTC</createdTime>
<ownerDesignName>ModelTest</ownerDesignName>
</IndexProxy>
</indexProxies>

It looks like Merge changed object class from FK to Index.

Comments

thatJeffSmith-Oracle Feb 13 2025

Your ENTRA users will get authenticated via JSON Web Tokens, and their Entra roles will determine which ORDS REST APIs they can hit.

When they hit an endpoint, it'll execute code in the database as the database user that owns the schema where the REST API is defined, not as Entra defiend end user. In fact, the Entra users won't have accounts in the database (they could, but wont' need to).

The :current_user field as far as ords is concerned would be the corresponding oauth2 client or JWT issued for the authorizied session.

Your prehook should be able to alter the session to set the context that would put your RLS/VPD security policy in play.

1 - 1

Post Details

Added on Aug 7 2024
1 comment
146 views