Case [in]sensitive passwords

[former_SQLA_member1694872]

Hi, I have a database that was done unload / reload and the individual who made the option selected case sensitive. Now how do I change case sensitive password for off? Set casesentitivepassword = off ??

[johnsmirnios]

Except in very, very old versions of SQLAnywhere, passwords are always case sensitive: http://dcx.sybase.com/index.html#sa160/en/dbusage/thdbcs.html

[VolkerBarth]

Where "very, very old" means "v9 or older", IIRC...

Note: When unloading such a very, very old and case-insensitive database into a new version, existing passwords will remain case-insensitive even in the new version (until you modify them, of course) - cf. the help.

[johnsmirnios]

Thank you. It was older than I cared to research because the oldest version on dcx was case-sensitive. 🙂

[VolkerBarth]

Well, I regularly have to cope with even much older versions than those very, very old ones...:)

[graeme_perrow]

John is correct except that passwords reloaded from an old database with case-insensitive passwords are still case-insensitive. Once those passwords are changed, they will become case-sensitive.

[VolkerBarth]

It that not what I had already mentioned in my comment? Or have I missed a subtle difference?

[graeme_perrow]

Yes, that's exactly what you had in your comment. I just wanted to... um... I thought I should... It was really... OK, I got nothing. Total fail on my part.

[VolkerBarth]

Thanks for the clarification - and w.r.t. feeling "very, very old" - been there, too:)