Trying to run - 'alter role warehouse_user unlock' on Sybase IQ
Failed due to SQL Anywhere Error -131: Syntax error near 'unlock' on line 1
someone knows why?
Asked
Active
Viewed 167 times
0
-
I found [this older information](https://sqlanywhere-forum.sap.com/questions/17290/how-to-manually-unlock-a-locked-user-account-in-sqla16) that claims a different `ALTER` command to unlock accounts, if it may possibly help. – Paul T. May 08 '22 at 13:45
1 Answers
1
The alter role statement doesn't appear to have anything to do with locked users (or roles):
Assuming the objective is to unlock a user account ... older versions of IQ (eg, 12.6, 12.7) had a stored proc named sp_iqlocklogin (currently unable to find an online reference); this proc appears to have been deprecated in favor of the alter user statement:
alter user <user_id> reset login policy- IQ - Unlocking User Accounts
- SQLAnywhere - ALTER USER statement
markp-fuso
- 28,790
- 4
- 16
- 36