DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle roles export

  1. #1
    Join Date
    Apr 2002
    Posts
    4
    Hi,

    might be a dumb question, but how do you export oracle roles from working db to import them to development db? Or do I have to create them manually and only them use imp procedure to import data?

    Great thanks in advance.
    REMOVEdima@klasco.lt

  2. #2
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    You will have to do a user level or database level export to export thsi.

    Vijay.
    Say No To Plastics

  3. #3
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    If I have understood well, you want to export the roles assigned to a user in the database.

    The only option to do this is export full=y, because this will create the user exactly it was. If not, you should create the user and grant all it need.

    Cheers

    Angel

  4. #4
    Join Date
    Apr 2002
    Posts
    4
    Thank you, guys.
    REMOVEdima@klasco.lt

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width