Re: copt roles to another database

From: Kirtikumar Deshpande <kedeshpande_at_yahoo.com>
Date: Tue, 27 Sep 2005 06:15:12 -0700 (PDT)
Message-ID: <20050927131512.65250.qmail@web50111.mail.yahoo.com>

How about creating the cr_roles.sql script from the source, and running it on the target before creating the users.

set pages 0 feedback off
spool cr_roles.sql
select 'create role ' || role || ';'
from dba_roles;
spool off

Cheers!

• Kirti
  • Yechiel Adar <adar76_at_inter.net.il> wrote:

> 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
>

---

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

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

Received on Tue Sep 27 2005 - 08:17:57 CDT