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 - Database Administration » Configuring Your Database » Managing user IDs, authorities, and permissions » Managing user permissions and authorities

 

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 CREATE USER 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:

  • the ability to connect to the database (assuming a password has been specified for the user)
  • the ability to view the data stored in the system views
  • the ability to execute most system stored procedures

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

A user with DBA authority 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

User IDs cannot:

Passwords are case sensitive and they cannot:

See Setting a password.

To create a new user (Sybase Central)

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

  2. Right-click Users & Groups and then choose New » User.

    The Create User Wizard appears.

  3. Follow the instructions in the wizard.

To create a new user (SQL)

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

  2. Execute a CREATE USER statement.

Example

This example adds a new user to the database with the user ID of M_Haneef and a password of Welcome.

CREATE USER M_Haneef
IDENTIFIED BY Welcome;
See also