1.4.2. Create Database Users for the Hive Metastore and/or the Oozie Metastore

Use one of the following options to create database users:

Option I: Allow HDP to create database users

Ensure that you have root privileges to the database instance.
Ensure that you deploy either a MySQL or an Oracle client on the master install machine.

On the master install machine, edit the master-install-machine/gsInstaller/gsInstaller.properties file and provide values for the following properties:

Table 1.1. Properties to create database users
Property Name	Notes
dbsysuser	Database system user credentials for Oracle instance. Required if value of `dbflavor` property is set to `oracle`.
dbsyspasswd
hive_dbuser	Database user credentials for Hive Metastore. Required if installing Hive.
hive_dbpasswd
oozie_dbname	Database name for Oozie Metastore. Required if installing Oozie and if `oozie_use_external_db` property is set to `yes`. See Reference - Configuration Properties (oozie_use_external_db).
oozie_dbuser	Database user credentials for Oozie Metastore. Required if installing Oozie and if `oozie_use_external_db` property is set to `yes`.
oozie_dbpasswd

On the master install machine, execute the setupDatabaseUsers auxiliary script file.
```
sh master-install-machine/gsInstaller/setupDataBaseUsers.sh
```

Option II: Manually create database users
1. Ensure that your database administrator creates the following databases and users:
  - For Hive:
    hive_dbname
    hive_dbuser
    hive_dbpasswd
  - For Oozie:
    oozie_dbname
    oozie_dbuser
    oozie_dbpasswd
2. On the master install machine, edit the master-install-machine/gsInstaller/gsInstaller.properties file and provide values for the Hive and/or Oozie users (as listed in the table above).

Legal notices