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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Managing User IDs and Permissions » Database permissions overview

Ownership permissions overview Next Page

Table and views permissions overview

There are several distinct permissions you may grant to user IDs concerning tables and views:

Permission Description
ALTER Permission to alter the structure of a table or create a trigger on a table.
DELETE Permission to delete rows from a table or view.
INSERT Permission to insert rows into a table or view.
REFERENCES Permission to create indexes on a table and to create foreign keys that reference a table.
SELECT Permission to look at information in a table or view.
UPDATE Permission to update rows in a table or view. This can also granted on a set of columns in a table or view.
ALL All the above permissions.