SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

Table 10 Altering Objects in an SQL/MX Database (continued)
Statement, Command or UtilityOperationObject
Revoke privileges REVOKE statement
ALTER TRIGGER statement
nl
Enable trigger
nl
Trigger
ALTER TRIGGER statementDisable trigger
GRANT statement
nl
Grant privilege
nl
View
REVOKE statementRevoke privilege
For more information on altering SQL/MX database objects, see:
• “Understanding and Planning SQL/MX Tables” (page 29)
• “Reviewing and Setting System Defaults” (page 68)
• “Creating an SQL/MX Database” (page 73)
• “Managing Database Applications” (page 212)
• The SQL/MX Reference Manual
• SQL/MX Guide to Stored Procedures in Java
Authorization Requirements for Altering Database Objects
Table 11 (page 163) describes the authorization requirement for each alter operation.
Table 11 Authorization Requirements for Altering Database Objects
Authorization RequirementsOperation
To alter an index with the ALTER INDEX statement, you must own its schema or
be the super ID.
nl
“Altering SQL/MX Indexes”
(page 164)
To alter an index using the FIXUP utility, you must be the super ID. For more
information, see the SQL/MX Reference Manual.
To alter a partition with the MODIFY utility, you must be the owner of its schema
or be the super ID.
“Altering Partitions for SQL/MX
Tables and Indexes” (page 164)
To alter an SQL/MP alias with the ALTER SQLMP ALIAS statement, you must own
its schema or be the super ID.
“Altering SQL/MP Aliases”
(page 165)
See the SQL/MX Guide to Stored Procedures in Java.“Altering SPJs” (page 165)
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 System Defaults”
(page 165)
To alter a table with the ALTER TABLE statement, you must own its schema or be
the super ID.
nl
“Altering SQL/MX Tables”
(page 166)
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.
nl
To alter a table using the FIXUP utility, you must be the super ID. For more
information, see the SQL/MX Reference Manual.
To alter a sequence generator with the ALTER SEQUENCE statement, you must
be the schema owner, the super ID or the object owner. To alter sequence
“Altering Sequence Generators”
(page 167)
generator privileges with the GRANT and REVOKE statements, you must have the
right to grant or revoke the USAGE privilege. The owner or creator of the sequence
generator, Security Administrator, and the super ID automatically have the USAGE
privilege on a sequence generator.
Altering Objects in an SQL/MX Database 163