Creating new users

The DBA or user with USER ADMIN authority can create new users using the CREATE USER statement. For example:

StepsAdding a new user to a database

This example adds user ID M_Haneef to a database with password welcome.

  1. From Interactive SQL, connect to the database as a user with DBA or USER ADMIN authority.

  2. Issue the SQL statement:

    CREATE USER M_Haneef
    IDENTIFIED BY welcome
    

Initial permissions for new users

By default, new users are not assigned any permissions beyond connecting to the database and viewing the system tables. In order 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”.

Using a dbisql command file to set up new users

You may want to put commands for setting up new users into a dbisql command file. Command files help you standardize the way you perform processes you repeat over time. For details on using command files, see Chapter 2, “Using Interactive SQL (dbisql),” in the Utility Guide.

Creating users in Sybase Central

StepsCreating a user in Sybase Central

  1. Connect to the database.

  2. Right-click the Users & Groups folder.

  3. Choose New > User. The Create User wizard leads you through the process.

For more information, see the Sybase Central Online Help for the IQ plug-in.