Contents Index Managing individual user IDs and permissions Changing a password

ASA Database Administration Guide
  Managing User IDs and Permissions
    Managing individual user IDs and permissions

Creating new users


In both Sybase Central and Interactive SQL, you can create new users. In Sybase Central, you can 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, new users are not assigned any permissions beyond connecting to the database and viewing the system tables. To access tables in the database, they 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, as discussed in Special groups.

To create a new user (Sybase Central)

  1. Open the Users & Groups folder.

  2. Click the New User button on the toolbar.

  3. Follow the instructions in the wizard.

To create a new user (SQL)

  1. Connect to a database with DBA authority.

  2. Execute a GRANT CONNECT TO statement.

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


Contents Index Managing individual user IDs and permissions Changing a password