7 Replies Latest reply on Dec 27, 2012 2:05 PM by Nadeem M

    DBMS_METADATA.GET_DDL - Required permissions in absense of SELECT_CATALOG_R


      In our production database SELECT_CATALOG_ROLE cannot be given to any normal user because of Security policy.

      I am normal user and I would like to use DBMS_METADATA.GET_DDL to get the DDL's of all the objects for creation of physical data model using tool.
      In absense of SELECT_CATALOG_ROLE, are there any alternate roles/grants present which can be given to the normal user so that he/she can use GET_DDL for any object in the database?

      Many Thanks in Advance!