Sybase IQ and Encrypted Passwords

Question

I have need to use the ENP (Encrypted Password) parameter with Sybase IQ. The documentation has a good reference on how to use it but not how to generate the password ... so how does one generate the encrypted password for use with the ENP connection parameter??

Thanks in advance

Answer 1

I'm fairly certain it's when you define the DSN in the ODBC Control Panel--or whatever other utility Sybase provides to define a connection on other platforms. When the DSN is stored in file or the registry, you should see the ENP parameter defined rather than PWD.

And unless there's an asymmetric algorithm involved--with the private key definable by the sa--I wouldn't consider this to be better than obfuscation. That is, lock down the capabilities of the user!