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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Configuring Your Database » Managing user IDs, authorities, and permissions » Database permissions and authorities overview » Permissions overview


Permissions explicitly set for the user or group

You can give a user permission to execute system procedures and functions by granting EXECUTE permission for that object.

For tables, views, and dbspaces, there are several distinct permissions you may grant to user IDs:

Permission Description
ALTER Permission to alter the structure of a table or create a trigger on a table.
CREATE ON Permission to create database objects on the specified dbspace.
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.

For more information about the permissions you can set on database objects, see GRANT statement.