RE: copt roles to another database

From: Gogala, Mladen <MGogala_at_allegientsystems.com>
Date: Tue, 27 Sep 2005 11:15:00 -0400
Message-ID: <A2C7821363A0544987988F6BCCE941B5060865@pegasus.lawaudit.com>

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_at_inter.net.il] 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

--

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 27 2005 - 10:15:01 CDT