Fujitsu 5.0L10 Manual Do Utilizador

If a table and index is added, define the optimization information for them. 
 

·  Defining optimization information (SET STATISTICS statement) 

 

·  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." 

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