Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

I am implementing max_failed_login_attempts and auto_unlock_time. I find reference to "manually unlocking user accounts", but I can not find the SQL command to execute to do this so I can provide administrators the command to unlock a locked account.

asked 01 Jul '13, 21:22

Bill%20Aumen's gravatar image

Bill Aumen
accept rate: 16%

edited 02 Jul '13, 09:45

Volker%20Barth's gravatar image

Volker Barth

Hi Bill,

The ALTER USER SQL command can be used to manually unlock a user account.


Any user with the MANAGE ANY USER privilege can perform this action.

permanent link

answered 02 Jul '13, 09:10

Mikel%20Rychliski's gravatar image

Mikel Rychliski
accept rate: 34%

Thanks Mikel. So that's why a keyword search of "lock" or "unlock" didn't get me anywhere.

(02 Jul '13, 10:27) Bill Aumen

Antoher solutions is usage of login policies in sql anywhere Login Policy "normal" and other "blockeds" and then blockeds policy set the blocked to ON.

And then set with sql "Alter role userName " the policy for user.

Example usage:

permanent link

answered 13 Jun '18, 12:42

sistepar's gravatar image

accept rate: 0%

edited 13 Jun '18, 12:43

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 01 Jul '13, 21:22

question was seen: 7,625 times

last updated: 13 Jun '18, 12:43