Importing roles
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Importing roles

  1. #1
    Join Date
    Jul 2000
    Posts
    31
    Hi:

    What is an easy way to export user-defined roles from one database and import it into another database instance?

    Thanks,

    Una.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    nop, you cant import roles unless FULL=Y is used in export

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Possible thru a script.
    Otherwise export and import only Object definitions with ignore=y option which grants all the privileges and grants.

    * export with full=y and rows=n and import with ignore=y

  4. #4
    Join Date
    Jul 2000
    Posts
    31
    I'm trying to only import 2 specific users (objects and all the roles/privileges granted to these users). I can't import the entire database as it is a development database and has a lot of test users and objects that I don't need in my production database...

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    export full with no data and import only Object definitions of the users you wanted with ignore=y option which grants all the privileges and roles to those users.

    export userid/password full=y or users=user1,user2 and rows=n
    import userid/password ignore=y
    fromuser=user1,user2
    touser=user1,user2

    [Edited by sreddy on 01-02-2001 at 04:42 PM]

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