ASA Database Administration Guide
Managing User IDs and Permissions
Managing groups
You can add existing users to groups or add groups to other groups in both Sybase Central and Interactive SQL. In Sybase Central, you can control group membership on the property sheets of users or groups. In Interactive SQL, you can make a user a member of a group with the GRANT statement.
When you assign a user membership in a group, they inherit all the permissions on tables, views, and procedures associated with that group.
Only the DBA can grant membership in a group.
To add a user or group to another group (Sybase Central)
Open the Users & Groups folder.
Right-click the user/group that you want to add to another group and choose Properties from the popup menu.
Click the Membership tab of the property sheet.
Click Join to open the Join Groups dialog.
Select the desired group and click OK. The user or group associated with the property sheet is then added to this desired group.
To add a user or group to another group (SQL)
Connect to a database.
Execute a GRANT MEMBERSHIP IN GROUP statement, specifying the desired group and the users involved.
Grant the user M_Haneef membership in the personnel group:
GRANT MEMBERSHIP IN GROUP personnel TO M_Haneef
See also