Re: [Q] How to recreate the role?
- From: Yechiel Adar <adar666@xxxxxxxxxxxx>
- Date: Mon, 08 May 2006 18:54:05 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » Re: [Q] How to recreate the role?