sp_iqmodifylogin Procedure

Assigns a user to a login policy.

Syntax1

call sp_iqmodifylogin 'userid', ['login_policy_name']

sp_iqmodifylogin 'userid', ['login_policy_name']

Requires the MANAGE ANY USER system privilege.

Parameters
Parameter	Description
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.

Assigns user joe to a login policy named expired_password:

sp_iqmodifylogin 'joe', 'expired_password'

Assigns user joe to the root login policy:

call sp_iqmodifylogin ('joe')