CHAPTER 10 Managing User IDs and Permissions

Creating new users

A new user is added to a database by the DBA using the GRANT CONNECT statement. For example:

To add a new user to a database, with user ID M_Haneef and password welcome:

1 From DBISQL, connect to the database as a user with DBA authority.

2 Issue the SQL statement:

Initial permissions for new users

Using a DBISQL command file to set up new users

GRANT CONNECT TO M_Haneef

IDENTIFIED BY welcome

Only the DBA has the authority to add new users to a database.

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”.

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 the chapter “Getting Started with DBISQL” in the Introduction to Adaptive Server IQ.

Creating users in

Sybase Central

To create a user in Sybase Central:

1 Connect to the database.

2 Click the Users and Groups folder for that database.

3Double-click Add User. A Wizard is displayed, which leads you through the process.

For more information, see the Sybase Central online Help.

Changing a password

Changing a user’s

If you have DBA authority, you can change the password of any existing user

password

with the following command:

 

357

Page 377
Image 377
Sybase 12.4.2 Creating new users, Changing a password, With the following command, 357, To create a user in Sybase Central