SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Adding, Altering, and Dropping SQL/MX Database
Objects
HP NonStop SQL/MX Installation and Management Guide—523723-004
9-3
Authorization Requirements for Adding Database
Objects
Authorization Requirements for Adding Database Objects
Table 9-2 describes the authorization requirement for each add operation.
Table 9-2. Authorization Requirements for Adding Database Objects
Operation Authorization Requirements
Adding Catalogs
Any user on a node can use the CREATE CATALOG statement to
add a catalog to the node.
Adding Columns
To use the ALTER TABLE statement to add a column to a table, you
must own the table’s schema or be the super ID.
Adding Constraints
To use the ALTER TABLE statement to add a constraint to a table,
you must own the table’s schema or be the super ID, and you must
also have access to all partitions of both the referenced and the
referencing tables. To add a constraint that refers to a column in
another table, you must have REFERENCES privileges on that
column.
Adding Indexes
To use the CREATE INDEX statement to create an SQL/MX index,
you must own the schema for the underlying table or be the super ID,
and have access to all partitions of the underlying table.
Adding Partitions to
Tables and Indexes
To use the MODIFY utility to add a partition to a table of index, you
must own its schema or be the super ID.
Adding Schemas
To use the CREATE SCHEMA statement to create a schema.
Adding SQL/MP
Aliases
To use the CREATE SQLMP ALIAS statement to add an SQL/MP
alias, you must be the owner of the schema or be the super ID.
Adding Stored
Procedures in Java
(SPJs)
To use the CREATE PROCEDURE statement to add an SPJ, you
must be the owner of the schema, or be the super ID, and have read
access to the Java class file or JAR file that contains the SPJ method.
For more information, see the SQL/MX Guide for Stored Procedures
in Java.
Adding Tables
To use the CREATE TABLE statement to add a table, you must own
its schema or be the super ID.
Adding Triggers
Adding a trigger can affect up to three schemas, each with its own
authorization requirements:
•
The schema where the trigger is created. You must either own
this schema or be the super ID.
•
The schema where the subject table exists. You must either own
this schema or be the super ID.
•
The schema where the referenced table exists. You must have
correct privileges on the referenced table or be the super ID.
Adding Views
To use the CREATE VIEW statement to add a view, you must have
SELECT privileges for the objects underlying the view and either own
the schema where the view resides or be the super ID.