
Access Requirements for SQL Objects
Type Command Authority Required
CREATE CONSTRAINT Must be the:
- local owner of the underlying table
- local SUPER.SUPER
- local group manager
- remote owner with
PURGE authority for the table and
READ authority for the underlying table.
CREATE INDEX Must be the:
- local owner of the object
- local SUPER.SUPER
- local group manager
- remote owner with
PURGE authority for the table and
READ and WRITE authority for the underlying table and
WRITE authority for the USAGES table of catalogs
that describes the underlying table.
CREATE TABLE READ and WRITE authority for all affected catalogs.
CREATE VIEW
Shorthand
WRITE authority for ...