sp_iqmodifyadmin Procedure

Sets an option on a named login policy to a certain value. If no login policy is specified, the option is set on the root policy. In a multiplex, sp_iqmodifyadmin takes an optional parameter that is the multiplex server name.

Syntax1

call sp_iqmodifyadmin (‘policy_option_name’, ‘value_in’ ,[’login_policy_name’] ) 

Syntax2

sp_iqmodifyadmin policy_option_name’, ‘value_in’ ,’login_policy_name 

Syntax3

sp_iqmodifyadmin policy_option_name, value_in, ,login_policy_name

Syntax 4

sp_iqmodifyadmin policy_option_name’, ‘value_in’ ,’login_policy_name ’ ,’server_name 

Usage

Parameters

Parameter

Description

policy_option_name

The login policy option to be changed.

value_in

New value for the login policy option.

login_policy_name

Name of the login policy whose login policy option needs to be changed.

Permissions

Requires DBA authority.

Examples

Sets the login option locked to ON for the policy named lockeduser:

call sp_iqmodifyadmin ('locked','on','lockeduser')

Sets the login option locked to ON for the policy named lockeduser on the multiplex server named Writer1:

call sp_iqmodifyadmin ('locked','on','lockeduser','Writer1')
Related reference
sp_expireallpasswords Procedure
sp_iqaddlogin Procedure
sp_iqcopyloginpolicy Procedure
sp_iqmodifylogin Procedure
sp_iqpassword Procedure