Creating a group with a name and password
Connect to the database as a user with either DBA or both USER ADMIN and PERMS ADMIN authority. USER ADMIN is needed for CREATE USER, and PERMS ADMIN is needed for GRANT GROUP.
Create the group's user ID just as you would any other user ID, using the following SQL statement:
CREATE USER 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 a group in Sybase Central
Connect to the database.
Right-click the Users & Groups folder.
Choose New > Group. A wizard leads you through the process.
For more information, see the Sybase Central online Help.
