Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Reference » Using SQL » SQL statements » SQL statements (A-D)

 

ALTER LOGIN POLICY statement

Use this statement to alter an existing login policy.

Syntax
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 }
Parameters
  • 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.

Remarks

When a login policy is altered, changes are immediately applied to all users.

Permissions

Must have DBA authority.

Side effects

None.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Examples

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;