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 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 namedsp_iqlocklogin
(currently unable to find an online reference); this proc appears to have been deprecated in favor of thealter user
statement:alter user <user_id> reset login policy