This discussion is archived
7 Replies Latest reply: Dec 27, 2012 6:05 AM by 881508 RSS

DBMS_METADATA.GET_DDL - Required permissions in absense of SELECT_CATALOG_R

957521 Newbie
Currently Being Moderated

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!


  • Correct Answers - 10 points
  • Helpful Answers - 5 points