How to manually unlock a locked user account in SQLA16

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 Aumen
2.1k●35●47●75
accept rate: 16%

edited 02 Jul '13, 09:45

Volker Barth
40.2k●361●550●822

flat view

2 Answers:

active answers oldest answers newest answers popular answers

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 Rychliski
2.1k●16●41
accept rate: 32%

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

flat view

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 '18, 12:42

sistepar
11●2
accept rate: 0%

edited 13 Jun '18, 12:43

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

user-management ×25
login ×15
account ×3
locked ×2

question asked: 01 Jul '13, 21:22

question was seen: 7,313 times

last updated: 13 Jun '18, 12:43

SAP SQL Anywhere

How to manually unlock a locked user account in SQLA16

Follow this question

Related questions