Re: copt roles to another database
- From: Kirtikumar Deshpande <kedeshpande@xxxxxxxxx>
- To: adar76@xxxxxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 27 Sep 2005 06:15:12 -0700 (PDT)
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@xxxxxxxxxxxx> 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
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
