Filter
Top Products
Managing groups
364
3 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
❖ 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:
1 Connect to the database as a user with DBA authority, or as the group user
ID
personnel.
2 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.
Adding users to
groups in Sybase
Central
❖ To add a user to a group in Sybase Central:
1 Connect to the database.