This section discusses preparations for database creation.
Before a database can be created, the following environment variables must be set in the client environment definition. (For details about how to set client environment variables, see the manual HiRDB Version 8 UAP Development Guide):
If the password of the authorization identifier of the HiRDB administrator is the same character string as the authorization identifier, use the GRANT definition SQL to change the password. To do this, execute the following SQL with the database definition utility (pddef) or HiRDB SQL Executer:
The CREATE SCHEMA definition SQL is used to define a schema. To define a schema, either the database definition utility (pddef command) is used or an appropriate UAP is created. Only one schema can be defined for each user.
Before a user other than the HiRDB administrator can create a database, the HiRDB administrator must grant an appropriate user privilege to this user. Use the GRANT definition SQL to grant the necessary user privilege to the user who will be creating databases. The following privileges are required:
For details about user privileges, see the manual HiRDB Version 8 System Operation Guide.
GRANT CONNECT TO USER002 IDENTIFIED BY HIRDB002;
GRANT SCHEMA TO USER002;
GRANT RDAREA RDAREA01 TO USER002;
When storing data in a database, you can use a facility to convert the data. Evaluate whether or not to use the following facilities. For details about these facilities, see the manual HiRDB Version 8 System Operation Guide.