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. They also inherit any inheritable authorities.

Only a user with DBA authority can grant membership in a group.

 To add a user or group to another group (Sybase Central)

  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

  2. Click Users & Groups.

  3. Double-click a user or group.

  4. For a user:

    • From the File menu, choose New » Memberships.

    For a group:

    • Click the Memberships tab.
    • From the File menu, choose New » Memberships.

  5. In the Name list, double-click a group.

    The new group appears on the Memberships tab in the right pane.

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

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

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

 Example
 See also
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0