NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
S-16
Authorization Requirements for SQL Statements
Authorization Requirements for SQL Statements
Statement Authority Required
DCL
LOCK TABLE
UNLOCK TABLE
Read authority to the table or view and to underlying tables of
the view
DDL*
ALTER* Generalized ownership of the object (or for an index, of the
underlying table), program file, or catalog being altered; for a
program, you must also have read and write authority to the
catalogs that describe the program and the objects referenced in
the program
COMMENT* Generalized ownership of the table or view (or for an index, of
the underlying table) referenced by the comment
CREATE
COLLATION*
Read authority for the collation source file or the collation
specified in the LIKE clause and its catalog
CREATE
CONSTRAINT*
Generalized ownership and read authority for the underlying
table
CREATE CATALOG* Write authority for the SQL.CATALOGS table on the node
where the catalog is to reside
CREATE INDEX* Generalized ownership and read and write authority for the
underlying table; also write authority to the USAGES table of
catalogs that describe the underlying table
CREATE TABLE* Read and write authority to the catalogs that describe the table
CREATE VIEW*
(shorthand)
Write authority to the USAGES table of catalogs that describe
the underlying tables or views
CREATE VIEW*
(protection)
Generalized ownership of the underlying table and read and
write authority to that table and all associated indexes unless the
view security specifies read and write authority for super ID
only
DROP CATALOG* Read and purge authority to the catalog being dropped; read and
write authority to SQL.CATALOGS
DROP CONSTRAINT*
DROP INDEX*
Generalized ownership of the underlying table
DROP COLLATION*
DROP PROGRAM*
DROP TABLE*
DROP VIEW*
Purge authority to the object being dropped
UPDATE STATISTICS* Generalized ownership of the table for which the statistics are
updated
* All DDL statements require authority to read and write to any catalogs affected by the change in addition to
any other requirements listed previously.