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.
call sp_iqmodifyadmin (‘policy_option_name’, ‘value_in’ ,[’login_policy_name’] )
sp_iqmodifyadmin ‘policy_option_name’, ‘value_in’ ,’login_policy_name ’
sp_iqmodifyadmin policy_option_name, value_in, ,login_policy_name
sp_iqmodifyadmin ‘policy_option_name’, ‘value_in’ ,’login_policy_name ’ ,’server_name ’
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.
Requires DBA authority.
ALTER LOGIN POLICY statement in Chapter 1, “SQL Statements,” in Reference: Statements and Options.
Example 1 Sets the login option locked to ON for the policy named lockeduser.
call sp_iqmodifyadmin ('locked','on','lockeduser')
Example 2 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')
