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:
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.
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.
