ASA Database Administration Guide
Managing User IDs and Permissions
Managing individual user IDs and permissions
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:
add it to other groups
set its permissions on tables, views, and procedures
set it as the publisher or as a remote user of the database
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)
Open the Users & Groups folder.
Click the New User button on the toolbar.
Follow the instructions in the wizard.
To create a new user (SQL)
Connect to a database with DBA authority.
Execute a GRANT CONNECT TO statement.
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