dbTalk Databases Forums  

Can roles be copied?

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Can roles be copied? in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Randy Harris
 
Posts: n/a

Default Can roles be copied? - 02-15-2005 , 05:03 PM






Is there a way to copy users or roles and their grants from one instance to
another? Perhaps using "exp full=y", then imp?




Reply With Quote
  #2  
Old   
Mark D Powell
 
Posts: n/a

Default Re: Can roles be copied? - 02-16-2005 , 10:01 AM






Do you want all users or just certain users? If all users then you can
use a full exp with rows=n to extract all DDL, grants, users, roles,
etc... and then import that.

You can use a user export for just one user's objects but this will not
get roles.

The create script for a role is fairly easy to generate from the
dictionary views or you can cut it out of a full exp dump with a little
editing code.

HTH -- Mark D Powell --


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.