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 ?? |
Except in very, very old versions of SQLAnywhere, passwords are always case sensitive: http://dcx.sybase.com/index.html#sa160/en/dbusage/thdbcs.html 1
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.
(22 May '13, 09:55)
Volker Barth
Replies hidden
Thank you. It was older than I cared to research because the oldest version on dcx was case-sensitive. :)
(22 May '13, 09:58)
John Smirnios
Well, I regularly have to cope with even much older versions than those very, very old ones...:)
(22 May '13, 10:00)
Volker Barth
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.
(22 May '13, 18:09)
Graeme Perrow
Replies hidden
It that not what I had already mentioned in my comment? Or have I missed a subtle difference?
(23 May '13, 03:19)
Volker Barth
2
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.
(23 May '13, 08:51)
Graeme Perrow
Thanks for the clarification - and w.r.t. feeling "very, very old" - been there, too:)
(23 May '13, 09:52)
Volker Barth
|