Use sp_locklogin to lock and unlock accounts or to display a list of locked accounts. You must be a system security officer to use sp_locklogin.
The syntax is:
sp_locklogin [ {login_name }, { "lock" | "unlock" } ]
where:
login_name is the name of the account to be locked or unlocked. The login name must be an existing valid account.
all indicates to lock or unlock all login accounts on an Adaptive Server, except those with sa_role.
lock | unlock specifies whether the account is to be locked or unlocked.
To display a list of all locked logins, use sp_locklogin with no parameters.
You can lock an account that is currently logged in, and the user is not locked out of the account until he or she logs out. You can lock the account of a database owner, and a locked account can own objects in databases. In addition, you can use sp_changedbowner to specify a locked account as the owner of a database.
Adaptive Server ensures that there is always at least one unlocked system security officer’s account and one unlocked system administrator’s account.
