ASA Database Administration Guide
  Managing User IDs and Permissions
    Managing groups

Creating groups

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

The GROUP permission, which gives the user ID the ability to have members, is not inherited by members of a group. Otherwise, every user ID would automatically be a group as a consequence of its membership in the special PUBLIC group.

To create a new group (Sybase Central)

1. Open the Users & Groups folder.

2. Click the New Group button on the toolbar.

3. Follow the instructions in the wizard.

To create a new group (SQL)

1. Connect to a database.

2. Execute a GRANT GROUP TO statement. If the user ID you cite in this statement has not already been created, you need to create it first.

Example 

Create the user ID personnel.

GRANT CONNECT
TO personnel
IDENTIFIED BY group_password

Make the user ID personnel a group.

GRANT GROUP TO personnel

See also

• GRANT statement

• Creating new users