2 Replies Latest reply on May 13, 2019 1:03 PM by Philip Stoyanov-Oracle

    Oracle Data modeller doesn't seem to save grants on Views

    user7542606

      Hi,

      I'm using Oracle Data modeller 18.4.  I have a logical & physical model of about 10 views.  I have a separate .ddl file that contains all relevant (select) grants on the views.

      I import the .ddl file into the model, do the merge, and then preview a DDL of one of the views.  None of the 'GRANT SELECT....' statements appear.

      The users are in the model.

      I do the same steps with tables in another model, and the grants stick.

       

      Although my preference is to import the grants in a file, if that's absolutely not possible,  where in the dialogues can I  explicitly add the grants?

       

      thanks!