SQL Anywhere does not support negative permissions. This means that you cannot revoke a permission that was not explicitly granted.

For example, suppose user bob is a member of a group called sales. If a user grants DELETE permission on a table T to group sales, then bob can delete rows from T. If you want to prevent bob from deleting from T, you cannot execute a REVOKE DELETE on T from bob, since the DELETE ON T permission was never granted directly to bob. In this case, you would have to revoke bob's membership in the sales group.

• GRANT statement
• REVOKE statement
• Permissions
• Grant permissions to users