I am implementing |
Hi Bill, The ALTER USER SQL command can be used to manually unlock a user account. ALTER USER <username> RESET LOGIN POLICY Any user with the MANAGE ANY USER privilege can perform this action. Thanks Mikel. So that's why a keyword search of "lock" or "unlock" didn't get me anywhere.
(02 Jul '13, 10:27)
Bill Aumen
|
Antoher solutions is usage of login policies in sql anywhere Login Policy "normal" and other "blockeds" and then blockeds policy set the blocked to ON. And then set with sql "Alter role userName " the policy for user. Example usage: http://dcx.sybase.com/index.html#sa160/en/dbreference/alter-user-statement.html |