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

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database configuration » User IDs, authorities, and permissions



A group can be thought of as a user ID with special permissions, such as the ability to have members. You grant and revoke permissions and authorities for a group in exactly the same manner as you do for users.

You can construct a hierarchy of groups where each group is a member of another group. A user ID may belong to more than one group; the user-to-group relationship is many-to-many.

You can create a group without a password. This enables you to prevent users from connecting to the database using the group user ID. See Groups without passwords.

To administer authorities and permissions for a group, follow the same procedures that you do for administering permissions and authorities for users. See Users.

To administer remote permissions for groups, see Granting and revoking remote permission for SQL Remote.

 Inheriting permissions and authorities

How user permissions are assessed
Creating a group
Granting group membership to an existing user or group
Revoking group membership
Permissions and authorities of groups
References to tables owned by groups
Groups without passwords
Special groups and users
Deleting a group from the database