Assigns a user to a login policy.
call sp_iqmodifylogin 'userid', ['login_policy_name']
sp_iqmodifylogin 'userid', ['login_policy_name']
DBA authority required.
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.
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')