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
2.1k354775
accept rate: 16%

edited 02 Jul '13, 09:45

Volker%20Barth's gravatar image

Volker Barth
32.1k327470688


Hi Bill,

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

ALTER USER <username> RESET LOGIN POLICY

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
2.1k1641
accept rate: 30%

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: http://dcx.sybase.com/index.html#sa160/en/dbreference/alter-user-statement.html

permanent link

answered 13 Jun, 12:42

sistepar's gravatar image

sistepar
112
accept rate: 0%

edited 13 Jun, 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

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "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:

×19
×13
×2
×2

question asked: 01 Jul '13, 21:22

question was seen: 3,595 times

last updated: 13 Jun, 12:43