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?
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?
Copyright © 2021 Jogjafile Inc.
The
alter rolestatement 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 namedsp_iqlocklogin(currently unable to find an online reference); this proc appears to have been deprecated in favor of thealter userstatement:alter user <user_id> reset login policy