Creating a new login policy

If you do not assign users to a login policy you create, they are assigned the root login policy.

To create a login policy (Sybase Central)

  1. Connect to the database as a user with DBA authority.

  2. Right-click Login Policies and then choose New » Login Policy.

    The Create Login Policy Wizard appears.

  3. Follow the instructions in the wizard.

To create a login policy (SQL)

  1. Connect to the database as a user with DBA authority.

  2. Execute a CREATE LOGIN POLICY statement. If you specify a login policy that already exists, the statement fails.

Example

This example creates the Test1 login policy with option values.

CREATE LOGIN POLICY Test1;
See also