ASA Database Administration Guide
  Managing User IDs and Permissions
    Managing groups

Revoking group membership

You can remove users or groups from a group in both Sybase Central and Interactive SQL.

Removing a user or group from a group does not delete them from the database (or from other groups). To do this, you must delete the user/group itself.

Only the DBA can revoke membership in a group.

To remove a user or group from another group (Sybase Central)

1. Open the Users & Groups folder.

2. Right-click the desired user/group and choose Properties from the popup menu.

3. Click the Membership tab of the property sheet.

4. Select the desired group to leave and click Leave. The user or group associated with the property sheet is then removed from this desired group.

To remove a user or group from another group (SQL)

1. Connect to a database.

2. Execute a REVOKE MEMBERSHIP IN GROUP statement, specifying the desired group and the users involved.

Example 

Remove the user M_Haneef from the personnel group:

REVOKE MEMBERSHIP
IN GROUP personnel
FROM M_Haneef

See also

• REVOKE statement

• Creating new users

• Deleting users from the database

• Deleting groups from the database