7 Replies Latest reply: Dec 27, 2012 8:05 AM by Nadeem M RSS

    DBMS_METADATA.GET_DDL - Required permissions in absense of SELECT_CATALOG_R

    957521
      Hi,

      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!