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 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. See Granting group membership to existing users or groups.
set its permissions on tables, views, and procedures. See Managing individual user IDs and permissions.
set it as the publisher or as a remote user of the database. See Managing SQL Remote permissions.
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.
The DBA can set the permissions granted automatically to new users by assigning permissions to the special PUBLIC user group. See Special groups.
When creating user IDs and passwords, the following restrictions apply. They cannot:
Open the Users & Groups folder.
From the File menu, choose New > User.
The Create User wizard appears.
Follow the instructions in the wizard.
Connect to a database as a user 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;