The Adaptive Server Enterprise and SQL Anywhere GRANT and REVOKE statements for granting privileges on individual database objects are very similar. Both allow SELECT, INSERT, DELETE, UPDATE, and REFERENCES privileges on database tables and views, and UPDATE privilege on selected columns of database tables. Both allow EXECUTE privilege to be granted on stored procedures.

For example, the following statement is valid in both Adaptive Server Enterprise and SQL Anywhere:

GRANT INSERT, DELETE
ON Employees
TO MARY, SALES;

This statement grants the privileges required to use the INSERT and DELETE statements on the Employees table to user MARY and to the SALES group.

Both SQL Anywhere and Adaptive Server Enterprise support the WITH GRANT OPTION clause, allowing the recipient of privileges to grant them in turn, although SQL Anywhere does not permit WITH GRANT OPTION to be used on a GRANT EXECUTE statement. In SQL Anywhere, you can only specify WITH GRANT OPTION for users. Members of groups do not inherit the WITH GRANT OPTION if it is granted to a group.

Adaptive Server Enterprise and SQL Anywhere use different models for database-wide privileges. SQL Anywhere employs a DBA role to allow a user full authority within a database. The System Administrator in Adaptive Server Enterprise enjoys this privilege for all databases on a server. However, the DBA role on a SQL Anywhere database is different from the permissions of an Adaptive Server Enterprise Database Owner, who must use the Adaptive Server Enterprise SETUSER statement to gain permissions on objects owned by other users.

• Adaptive Server Enterprise system and catalog procedures
• Users and groups