Copying User accounts with encrypted passwords from one IQ server to other server

[Former Member]

HI

We are in the process of moving server from one SybaseIQ server ( windows 2000) to new server IQ version 15.4 ( window 2008).

We are moving the user accounts from old server to new server. Since we cannot bcp out "sysuserperm" and update on new server like "syslogins" in ASE, Could you please help us by providing the necessary steps to do this in Sybase IQ.

Very much appreciated your help.

Regards

Joga

[Former Member]

It is good that you found the solution.

Looks like you did not checked sp_lg_get_ddl_users from the link I shared. This SP creates, GRANT CONNECT TO XXX IDENTIFIED BY ENCRYPTED '0sfg0f9sd0g9fd0s'

Regards,

Abhijit

[Former Member]

Hi Joga,

Refer IQ extended SPs : http://www.gvirtz-consulting.com/downloads

Regards,

Abhijit

[Former Member]

Thanks Abhijit,

I need to copy the user accounts with encrypted passwords. Have contacted SAP global support . they guided me by referring a procedure KBA.

This link provides DDL of various objects , which is also useful.

Thanks for your help

Regards

Joga