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.

Discuss this page in DocCommentXchange.
Send feedback about this page using email.