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?
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