Creating groups

To create a new group (Sybase Central)
  1. Connect to the database as a user with DBA authority.

  2. Right-click Users & Groups and then choose New » Group.

  3. Follow the instructions in the Create Group Wizard.

To create a new group (SQL)
  1. Connect to the database as a user with DBA authority.

  2. Execute a GRANT GROUP TO statement. If the user ID you specify in this statement has not been created, the statement fails.

Example

Create the user ID personnel.

CREATE USER personnel
IDENTIFIED BY group_password;

Make the user ID personnel a group.

GRANT GROUP TO personnel;
See also