What is an easy way to export user-defined roles from one database and import it into another database instance?
nop, you cant import roles unless FULL=Y is used in export
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
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...
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
[Edited by sreddy on 01-02-2001 at 04:42 PM]
Click Here to Expand Forum to Full Width