Use this statement to alter an existing login policy.
ALTER LOGIN POLICY policy-name policy-options
policy options : policy-option [ policy-option ... ]
policy-option :
policy-option-name = policy-option-value
policy-option-value : { UNLIMITED | root | legal-option-value }
policy-name The name of the login policy. Specify root to modify the root login policy.
policy-option-name The name of the policy option. To view a list of default login policy option names and descriptions, see the Remarks section of CREATE LOGIN POLICY statement.
policy-option-value The value assigned to the login policy option. If you specify UNLIMITED, no limits are used. If you specify default, the default limits are used. To view a list of default login policy option values, see the Remarks section of CREATE LOGIN POLICY statement.
When a login policy is altered, changes are immediately applied to all users.
Must have DBA authority.
None.
SQL/2003 Vendor extension.
The following example alters the Test1 login policy. This example changes the locked and max_connections options. The locked value indicates that users with the policy are prohibited from establishing new connections and the max_connections value indicates the number of concurrent connections allowed.
ALTER LOGIN POLICY Test1 locked=ON max_connections=5; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |