Importing roles

[una]

Hi:

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

Thanks,

Una.

[pando]

nop, you cant import roles unless FULL=Y is used in export

[sreddy]

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

[una]

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

[sreddy]

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]