sp_iqmodifylogin Procedure

Syntax 1

call sp_iqmodifylogin 'userid', ['login_policy_name']

Syntax 2

sp_iqmodifylogin 'userid', ['login_policy_name']

Parameters

• 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.

Privileges

You must have EXECUTE privilege on the system procedure, as well as the MANAGE ANY USER system privilege.

Example

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')