3.7.3 Creating an HADB user
Once you are able to enter SQL statements, create the HADB user necessary for creating and retrieving tables.
- Organization of this subsection
(1) Executing the SQL statement for creating an HADB user
To create an HADB user, you use the CREATE USER definition SQL statement. Here, the following HADB user is created as the HADB user for creating and retrieving tables:
-
User ID (authorization identifier): ADBUSER02
-
Password: #HelloHADB_02
Enter the SQL statement described below and press Enter.
Make sure that the last character you enter is a semicolon (;), or the SQL statement will not execute.
CREATE USER "ADBUSER02" IDENTIFIED BY '#HelloHADB_02';
This SQL statement creates the HADB user (ADBUSER02). The created user ADBUSER02 does not have the two privileges (the CONNECT privilege and the schema definition privilege) necessary for creating and retrieving tables. Therefore, you must grant the necessary privileges.
(2) Confirming the HADB user creation result
The message shown below is output when the HADB user (ADBUSER02) is created. An example of the output message follows.
- ■ Example of the output message
-
KFAA96403-I SQL processing completed.
After you have confirmed that the HADB user has been created, HADB user creation is complete.