Contents Index Creating groups Revoking group membership

ASA Database Administration Guide
  Managing User IDs and Permissions
    Managing groups

Granting group membership to existing users or 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)

  1. Open the Users & Groups folder.

  2. Right-click the user/group that you want to add to another group and choose Properties from the popup menu.

  3. Click the Membership tab of the property sheet.

  4. Click Join to open the Join Groups dialog.

  5. 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)

  1. Connect to a database.

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

Example 

Grant the user M_Haneef membership in the personnel group:

GRANT MEMBERSHIP
IN GROUP personnel
TO M_Haneef

See also


Contents Index Creating groups Revoking group membership