Sybase 12.4.2 manual Granting group membership to users, Managing groups, 364

Managing groups

3Give 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

❖To create a group in Sybase Central:

1 Connect to the database.

2 Click the Users and Groups folder for that database.

3 Double-click Add Group. A Wizard leads you through the process. For more information, see the Sybase Central online Help.

Granting group membership to users

Making a user a member of a group is done with the GRANT statement.

Membership in a group can be granted either by the DBA or by the group user

ID. You can grant user M_Haneef membership in a group personnel as follows:

1Connect to the database as a user with DBA authority, or as the group user ID personnel.

2Grant 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.

Adding users to groups in Sybase Central

❖To add a user to a group in Sybase Central:

1 Connect to the database.

364