-
Hi:
What is an easy way to export user-defined roles from one database and import it into another database instance?
Thanks,
Una.
-
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
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|