sp_locklogin

Description

Locks an Adaptive Server account so that the user cannot log in or displays a list of all locked accounts.

Syntax

sp_locklogin [loginame, "{lock | unlock}"]

Parameters

loginame

is the name of the account to be locked or unlocked.

lock | unlock

specifies whether to lock or unlock the account.

Examples

Example 1

Locks the login account for the user “charles”:

sp_locklogin charles, "lock"

Example 2

Displays a list of all locked accounts:

sp_locklogin

Usage

Permissions

Only a System Security Officer can execute sp_locklogin.

See also

System procedures sp_addlogin, sp_droplogin, sp_modifylogin, sp_password