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

Table 8 Adding Objects to an SQL/MX Database (continued)
Statement, Command or UtilityOperationObject
CREATE SCHEMA statementAddSchema
CREATE SEQUENCE statementAddSequence Generator
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 29)
• “Creating an SQL/MX Database” (page 73)
• “Managing Database Applications” (page 212)
• The SQL/MX Reference Manual
Authorization Requirements for Adding Database Objects
Table 9 (page 151) 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 152)
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 152)
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
“Adding Constraints” (page 154)
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.
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 155)
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 157)
To use the CREATE SCHEMA statement to create a schema.“Adding Schemas” (page 159)
To use the CREATE SEQUENCE statement to add a sequence generator, you must
own its schema or be the super ID.
“Adding Sequence Generators”
(page 159)
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 160)
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 160)
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 160)
Adding Objects to an SQL/MX Database 151