Forum Stats

  • 3,770,086 Users
  • 2,253,063 Discussions
  • 7,875,305 Comments

Discussions

Is it posible to detect changes in Roles/Privileges and Triggers between BD and DataModeler?

Hi:

I'm using DataModeler version Version 21.2.0.183

I'm generating some triggers in DataModeler, and when i compare my model with DB using the button Syncronize Data Dictionary with Model, there is no option to include Triggers.

When i show DDL PREVIEW in the table, the trigger code is showed, but not when i use the button Syncronize Data Dictionary with Model.

Any idea on how to detect those changes with the BD?

The same for Roles. The change is detected but no grant/revoke statements is generated with DDL Preview in Compare Model

Chers. Monica

Best Answer

Answers

  • Philip Stoyanov-Oracle
    Philip Stoyanov-Oracle Member Posts: 3,352 Employee
    Accepted Answer

    triggers are supported in import/sync operations and that is set by default.

    Here are some pictures:


    Philip

  • User_NXQOV
    User_NXQOV Member Posts: 2 Green Ribbon

    Hi Philip:

    Many thanks for your response.

    I did the same test, but triggers dit not apear in the Compare Model tree, when i click on Synchronize Data Dictionary With Model


    Here a screeenshot:

    Triggers doesn't apear in my Compare Model

    The DB version is 11.2 (with system user) and Oracle Data Modeler is Version 21.2.0.183

    I don't know if the issue is with the DB Version or with any preference.

    Any idea?

    Best Regards