Granting group membership to users

The GRANT statement makes a user a member of a group. Membership in a group can be granted either by the DBA or PERMS ADMIN authority.

For example, you can grant user M_Haneef membership in a group personnel as follows:

  1. Connect to the database as a user with DBA or PERMS ADMIN authority.

  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. If you do not want a specific user to access a particular table, view, or procedure, then do not make that user a member of a group that has permissions on that object.

You cannot revoke permissions for a specific user within a group.

Adding users to groups in Sybase Central

StepsAdding a user to a group in Sybase Central

  1. Connect to the database.

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

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