Explicit table and view privileges

You can explicitly grant privileges on tables and views.

Begin general-use programming interface information.

Db2 supports the following table and view privileges:

Table 1. Explicit table and view privileges
Table or view privilege	SQL statements allowed for a named table or view
ALTER	ALTER TABLE, to change the table definition
DELETE	DELETE, to delete rows
INDEX	CREATE INDEX, to create an index on the table
INSERT	INSERT, to insert rows
REFERENCES	ALTER or CREATE TABLE, to add or remove a referential constraint that refers to the named table or to a list of columns in the table
SELECT	SELECT, to retrieve data
TRIGGER	CREATE TRIGGER, to define a trigger on a table
UPDATE	UPDATE, to update all columns or a specific list of columns
GRANT ALL	SQL statements of all privileges

Start of change Db2 supports the following table privileges: End of change

Table 2. Explicit table privileges
Table privilege	Operations allowed for a named table
UNLOAD	UNLOAD utility, to unload data

End general-use programming interface information.