Sybase IQ, migrate users and passwords

[william-paul_philibert]

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

[Gisung]

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