get ddl for role .. need to copy a role from one database to other db
858164Jun 13 2011 — edited Jun 14 2011HI Gurus
Need some assistance, objective is to get the role ddl and then change the role name to new role.
i know this can be easily done by the toad or sql develper but i have to do this in many databases.
i am open to some suggestion but the easy/logical way i figure is through created the pl/sql code
and the problem is
*1.how do i get the ddl statements ?*
i have used this so for with the assistance from the interent
select dbms_metadata.get_granted_ddl ('ROLE', 'SELECT_CATALOG_ROLE') from dual+
but this only gives one row output and if i change dual to*dba_roles* it repeats the same statement ...
thanks for all the help
Edited by: 855161 on Jun 13, 2011 1:44 PM