Filter
Top Products
Defining optimization information for added definition
If a table and index is added, define the optimization information for them.
· Defining optimization information (SET STATISTICS statement)
Altering privileges
· Adding privilege information (GRANT statement)
· Deleting privilege information (REVOKE statement)
· Adding a role definition (CREATE ROLE statement)
- Adding a privilege to a role (GRANT statement)
- Granting the role privileges to a user (GRANT statement)
· Altering role privilege information (GRANT statement)
· Deleting a role definition (DROP ROLE statement)
· Removing a role privilege (REVOKE statement)
- Deleting a privilege for a table from a role
- Removing the role privileges from a user
Note that when a database definition is deleted or altered, the definition information is deleted or altered. Moreover,
the data itself (table or index) is deleted or altered at the same time. If the deletion or alteration of a database
definition is specified by mistake, important data may also be deleted. Always use care when deleting or altering a
database definition.
The following database is used in the examples in this section:
Database:
STOCKMN_DB
Schema:
STOCKS
Sequence:
SEQUENCE1
Tables:
STOCK and ORDER
View:
MASS_STOCK
Table DSOs:
STOCK_DSO and ORDER_DSO
Table DSIs:
STOCK_DSI and WEST_ORDER_DSI
Index DSO:
PRODUCT_IXDSO
Index DSI:
PRODUCT_IXDSI
Because of dependencies between definitions, the user must follow an alteration sequence that conforms to those
dependencies when altering a database definition. For information about basic alteration sequences, see Appendix B
"Sequential Relationships Among Definition Changes."
3.1.1 Altering a logical structure defining
Adding a schema definition (CREATE SCHEMA statement)
A new schema definition can be added to an existing database definition. To add a schema definition, specify the
CREATE SCHEMA statement in a similar manner as when defining a schema. For details about how to specify the
CREATE SCHEMA statement, see 2.6 "Defining a Logical Structure."
Example:
Adding a schema belonging to STOCKMN_DB.
116