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:

add the user to other groups. See Granting group membership to existing users or groups.
set the user's permissions on tables, views, and procedures. See Managing user permissions and authorities overview.
set the user as the publisher or as a remote user of the database. See User permissions.
assign a login policy to the user. By default, a user is assigned to the root login policy. However, you can create and assign custom login policies. See Managing login policies overview.

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:

begin with white space, single quotes, or double quotes
end with white space
contain semicolons

Passwords are case sensitive and they cannot:

begin with white space, single quotes, or double quotes
end with white space
contain semicolons
be longer than 255 bytes in length

See Setting a password.

To create a new user (Sybase Central)

Connect to the database as a user with DBA authority.
Right-click Users & Groups and then choose New » User.
Follow the instructions in the Create User Wizard.

To create a new user (SQL)

Connect to the database as a user with DBA authority.
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;