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