Granting group membership to users

The GRANT statement makes a user a member of a group. Membership in a group can be granted either by the DBA or by the group user ID.

For example, you can grant user M_Haneef membership in a group personnel as follows:

Connect to the database as a user with DBA authority, or as the group user ID personnel.
Grant membership in the group to M_Haneef with the following SQL statement:
```
GRANT MEMBERSHIP 
IN GROUP personnel
TO M_Haneef
```

When users are assigned membership in a group, they inherit all the permissions on tables, views, and procedures associated with that group. If you do not want a specific user to access a particular table, view, or procedure, then do not make that user a member of a group that has permissions on that object.

You cannot revoke permissions for a specific user within a group.

Adding users to groups in Sybase Central

Adding a user to a group in Sybase Central

Connect to the database.
Double-click the Users & Groups folder for that database, to open it. Groups are displayed in the left panel, and both users and groups are displayed in the right panel.
In the right panel, select the users you want to add to a group, and drag them to the group.

For more information, see the Sybase Central online Help.