SQL/MX 3.2 Management Manual (H06.25+, J06.14+)

Table 8 Adding Objects to an SQL/MX Database (continued)
Statement, Command or UtilityOperationObject
CREATE SCHEMA statementAddSchema
CREATE SQLMP ALIAS statementAddSQL/MP alias
CREATE PROCEDURE statementAddStored procedures in Java (SPJs)
CREATE TABLE statementAddTable
CREATE TRIGGER statementAddTrigger
CREATE VIEW statementAddView
For more information on creating (adding) objects, see:
• “Understanding and Planning SQL/MX Tables” (page 28)
• “Creating an SQL/MX Database” (page 72)
• “Managing Database Applications” (page 209)
• The SQL/MX Reference Manual
Authorization Requirements for Adding Database Objects
Table 9 (page 150) describes the authorization requirement for each add operation.
Table 9 Authorization Requirements for Adding Database Objects
Authorization RequirementsOperation
Any user on a node can use the CREATE CATALOG statement to add a catalog to
the node.
“Adding Catalogs” (page 151)
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 Columns to an SQL/MX
Table” (page 151)
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
“Adding Constraints” (page 153)
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.
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 Indexes to SQL/MX
Tables” (page 154)
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 Partitions to SQL/MX
Tables and Indexes” (page 156)
To use the CREATE SCHEMA statement to create a schema.“Adding Schemas” (page 158)
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 SQL/MP Aliases”
(page 158)
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
“Adding Stored Procedures in
Java (SPJs)” (page 159)
JAR file that contains the SPJ method. For more information, see the SQL/MX Guide
for Stored Procedures in Java.
To use the CREATE TABLE statement to add a table, you must own its schema or be
the super ID.
“Adding SQL/MX Tables”
(page 159)
150 Adding, Altering, and Dropping SQL/MX Database Objects