cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase IQ, migrate users and passwords

0 Kudos

Bonjour,

I need to create a Sybase IQ 16 Dev database with a Sybase IQ 15.4 Prod Database but I need to keep users and passwords from my Dev env.

Now that my database is upgraded, how can I replace the current users with the users from Sybase !Q 15 env?

Thanks for your time and support

Accepted Solutions (0)

Answers (3)

Answers (3)

Gisung
Advisor
Advisor
0 Kudos

Hi,

IQ system table is not allowed to edit by users.
This sp_displayroles procedure Displays all roles granted to a user-defined role or a user, or displays the entire hierarchical tree of roles.

I recommend to use Power Designer to extract those information.
You can download 30-Day trial version.
https://www.sap.com/product/data-mgmt/powerdesigner-data-modeling-tools.html
- Try 30-Day Free Trial

Best Regards,
Gi-Sung Jang

0 Kudos

Awesom Gi-sung, exactly what I was looking for.

I'm having more following questions regarding this procedures.

If I don't wan't to remove, one by one, all users from the currently retored procedure, is there any table I can edit to remove the users (like sysusers for Sybase ASE) ??

Last but no the least, is there some ways to list users from a specific role to eventually re-assing the users to the correcte role/s following the procedure in the linked document?

Bottom line the procedure following the restore of the database :

1. drop all restored users (comming from the wrong env (prod))

2. create dev users (from the dev env) to the newly restored database

3. re-assing the correct role to the correct user once the grant connect as been executed?

Thanks again for your time, support and expertise.

Gisung
Advisor
Advisor
0 Kudos

Hi,

Here is a KBA that explains how to migrate password to another IQ.

2026768 - How to extract password for user in IQ Database
https://launchpad.support.sap.com/#/notes/2026768

I hope this will help you.

Best Regards
Gi-Sung Jang