Re: [Q] How to recreate the role?

dba1 mcc wrote:

> 1. recreate "role"?
>
> 2. recreate "grant role" script?

You have not said what version.
Anyway in 9.2.0.6:

Use: select dbms_metadata.get_ddl('ROLE','role name') from dual to get the role ddl.
Use: select dbms_metadata.get_granted_ddl('SYSTEM_GRANT','user name') from dual
to get the system grants
and: select dbms_metadata.get_granted_ddl('ROLE_GRANT','user name') from dual
to get the roles that are granted to user.

Adar Yechiel
Rechovot, Israel

--
http://www.freelists.org/webpage/oracle-l