Syntax error near 'unlock' - 'alter role warehouse_user unlock'

223 Views Asked by At

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?

1

There are 1 best solutions below

0
On BEST ANSWER

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: