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-19
Authorization Requirements for Altering Database
Objects
•
SQL/MX Guide to Stored Procedures in Java
Authorization Requirements for Altering Database Objects
Table 9-4 describes the authorization requirement for each alter operation.
Table 9-4. Authorization Requirements for Altering Database Objects
Operation Authorization Requirements
Altering Indexes
To alter an index with the ALTER INDEX statement, you must own its
schema or be the super ID.
To alter an index using the FIXUP utility, you must be the super ID.
For more information about FIXUP, see the SQL/MX Reference
Manual.
Altering Partitions
To alter a partition with the MODIFY utility, you must be the owner of
its schema or be the super ID.
Altering SQL/MP
Aliases
To alter an SQL/MP alias with the ALTER SQLMP ALIAS statement,
you must own its schema or be the super ID.
Altering Stored
Procedures in Java
(SPJs)
See the SQL/MX Guide to Stored Procedures in Java.
Altering System
Defaults
To alter system defaults, you must be the super ID or a user to whom
the super ID has granted UPDATE privileges on this table. (All other
users have SELECT privileges on this table.)
Altering Tables
To alter a table with the ALTER TABLE statement, you must own its
schema or be the super ID.
To alter a table with the GRANT and REVOKE statements, you must
have both that privilege and the right to grant or revoke that privilege.
If the super ID user issues a GRANT or REVOKE statement using
the BY authid-grantor clause, the authid-grantor must hold the right to
grant or revoke the specified privileges. For more information, see the
SQL/MX Reference Manual.
To alter a table using the FIXUP utility, you must be the super ID. For
more information about FIXUP, see the SQL/MX Reference Manual.
Altering Triggers
To alter a trigger with the ALTER TRIGGER statement, you must own
its schema or be the super ID. Only the super ID can use ALTER
TRIGGER DISABLE ALL or ALTER TRIGGER ENABLE ALL.
Altering Views
To alter a view with GRANT and REVOKE statements, you must
have both that privilege and the right to grant or revoke that privilege.
If the super ID user issues a GRANT or REVOKE statement using
the BY authid-grantor clause, the authid-grantor must hold the right to
grant or revoke the specified privileges. For more information, see the
SQL/MX Reference Manual.