Creating groups

Creating a group with a name and password

Connect to the database as a user with DBA authority.
Create the group's user ID just as you would any other user ID, using the following SQL statement:
```
GRANT CONNECT
TO personnel
IDENTIFIED BY group_password
```
Give the personnel user ID the permission to have members, with the following SQL statement:
```
GRANT GROUP TO personnel
```

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

Creating groups in Sybase Central

Creating a group in Sybase Central

Connect to the database.
Click the Users & Groups folder for that database.
Double-click Add Group. A Wizard leads you through the process.

For more information, see the Sybase Central online Help.