1 Reply Latest reply on Sep 7, 2020 2:29 PM by Paul Jorstad

    ORDS_METADATA.ords_export.export_module deletes any other module privileges

    Paul Jorstad

      When exporting a module with select dbms_output.put_line( ords_export.export_module('myModule')) from dual the privileges are included by default. Fine!

      But I have created a privilege which protects many other modules as well. So if I later export another module protected by the same privilege, the former exported module is not included in the protected privilege anymore.

      So, question: How can I export two or more modules with both modules protected by the same privilege?

       

      Ords version: 20.2

       

      Thanks :-)