Creating groups

You can create a new group in both Sybase Central and Interactive SQL. You need DBA authority to create a new group.

To create a new group (Sybase Central)

Connect to the database as a user with DBA authority.
Right-click Users & Groups and then choose New » Group.

The Create Group Wizard appears
Follow the instructions in the wizard.

To create a new group (SQL)

Connect to the database as a user with DBA authority.
Execute a GRANT GROUP TO statement. If the user ID you specify in this statement has not been created, the statement fails.

Create the user ID personnel.

CREATE USER personnel
IDENTIFIED BY group_password;

Make the user ID personnel a group.

GRANT GROUP TO personnel;