Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Managing User IDs and Permissions » Managing groups

Creating groups Next Page

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 in the right pane 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. Select the user/group that you want to add to a group, and from the File menu choose New > Memberships.

    The New Memberships dialog appears.

  3. Select the desired group and click OK.

  4. The group membership appears on the Memberships tab in the right pane for the selected user/group.

To add a user or group to another group (SQL)