Remove a user or group from another group (Sybase Central)

Removing a user or group from a group does not delete them from the database (or from other groups). To do this, you must delete the user/group itself.

When you add a user to a group, the user inherits all the inheritable permissions assigned to that group. SQL Anywhere does not allow you to revoke a subset of the permissions that a user inherits as a member of a group because you can only revoke permissions that are explicitly given by a GRANT statement. If you need to have different permissions for different users, you can create different groups with the appropriate permissions, or you can explicitly grant each user the permissions they require.

 Remove a user or group from another group (SQL)

Removing a user or group from a group does not delete them from the database (or from other groups). To do this, you must delete the user/group itself.

When you add a user to a group, the user inherits all the inheritable permissions assigned to that group. SQL Anywhere does not allow you to revoke a subset of the permissions that a user inherits as a member of a group because you can only revoke permissions that are explicitly given by a GRANT statement. If you need to have different permissions for different users, you can create different groups with the appropriate permissions, or you can explicitly grant each user the permissions they require.

 See also

 Example

REVOKE MEMBERSHIP
IN GROUP personnel
FROM M_Haneef;