RE: copt roles to another database
- From: "Gogala, Mladen" <MGogala@xxxxxxxxxxxxxxxxxxxx>
- To: "'adar76@xxxxxxxxxxxx'" <adar76@xxxxxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Sep 2005 11:15:00 -0400
select dbms_metadata.get_ddl('ROLE',role) from dba_roles
should provide a collection for "CREATE ROLE" DDL statements.
--
Mladen Gogala
Ext. 121
-----Original Message-----
From: Yechiel Adar [mailto:adar76@xxxxxxxxxxxx]
Sent: Tuesday, September 27, 2005 9:41 AM
To: ORACLE-L
Subject: copt roles to another database
Hello
Oracle 9.2.0.5/6 on windows.
I am developing a script to merge two databases together using
transportable tablespaces (TTS) export/import.
I need to create a script to copy roles from one database to another, so
when I run the create users ddl it will work without problems.
How can I get a script to create the roles based on existing roles in
the database.
Dbms_metadata does not give option to create ddl for roles.
I searched the docs, Metalink and google without results.
TIA
--
Adar Yechiel
Rechovot, Israel
--
//www.freelists.org/webpage/oracle-l
Other related posts:
