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 ’
Parameters
- policy_option_name – The login policy option to be changed.
- value_in – New value for the login policy option.
- login_policy_name – Policy for which the login policy option is to be changed.
Privileges
You must have EXECUTE privilege on the
system procedure, as well as the MANAGE ANY
LOGIN POLICY system privilege.
Example
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')