sp_iqmodifylogin procedure

Function

Assigns a user to a login policy.

Syntax1

call sp_iqmodifylogin 'userid', ['login_policy_name']

Syntax2

sp_iqmodifylogin 'userid', ['login_policy_name']

Permissions

DBA authority required.

Usage

userid Variable that holds the name of the account to modify.

login_policy_name (Optional) Specifies the name of the login policy to which the user will be assigned. If no login policy name is specified, the user is assigned to the root login policy.

Examples

Example 1 Assigns user joe to a login policy named expired_password:

sp_iqmodifylogin 'joe', 'expired_password'

Example 2 Assigns user joe to the root login policy:

call sp_iqmodifylogin ('joe')

See also

“sp_iqmodifyadmin procedure”