SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
S-16
Authorization Requirements for SQL Statements
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)
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
DML
DELETE
INSERT
UPDATE
Read and write authority to the table or protection view being
deleted or modified; read authority to the tables, protection
views, and underlying tables of shorthand views in subqueries
of the statement
OPEN
FETCH
Read authority to the tables, protection views, and underlying
tables of shorthand views referred to in the SELECT statement
that defines the cursor; write authority, too, if the cursor is FOR
UPDATE
Table S-1. Authorization Requirements for SQL Statements (page 2 of 3)
Statement Authority Required