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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Managing User IDs and Permissions » Managing individual user IDs and permissions

Managing individual user IDs and permissions Next Page

Creating new users


You can create new users in both Sybase Central and Interactive SQL. In Sybase Central, you manage users or groups in the Users & Groups folder. In Interactive SQL, you can add a new user using the GRANT CONNECT statement. For both tools, you need DBA authority to create new users.

All new users are automatically added to the PUBLIC group. Once you have created a new user, you can:

Initial permissions for new users

By default, the permissions assigned to new users include:

To access tables in the database, new users need to be assigned permissions.

The DBA can set the permissions granted automatically to new users by assigning permissions to the special PUBLIC user group. See Special groups.

Restrictions on user IDs and passwords

When creating user IDs and passwords, the following restrictions apply. They cannot:

To create a new user (Sybase Central)
  1. Open the Users & Groups folder.

  2. From the File menu, choose New > User.

    The Create User wizard appears.

  3. Follow the instructions in the wizard.

To create a new user (SQL)
  1. Connect to a database as a user with DBA authority.

  2. Execute a GRANT CONNECT TO statement.

  3. Example

    Add a new user to the database with the user ID of M_Haneef and a password of Welcome.

    GRANT CONNECT TO M_Haneef
    IDENTIFIED BY Welcome;
    See also