Set Up Database Users Without Sharing DBA Credentials
If you do not wish to provide system Database Administrator (DBA) account details to
the Ambari Ranger installer, you can use the
dba_script.py Python script to
create Ranger DB database users without exposing DBA account information to the Ambari Ranger
installer. You can then run the normal Ambari Ranger installation without specify a DBA user
name and password.
Download the Ranger rpm using the yum install command:
yum install ranger-admin.
You should see one file named
- Get the script reviewed internally and verify that your DBA is authorized to run the script.
Execute the script by running the following command:
Pass all values required in the argument. These should include
db user, and other parameters.
If you would prefer not to pass runtime arguments via the command prompt, you can update the
/usr/hdp/current/ranger-admin/install.propertiesfile and then run:
python dba_script.py -q
When you specify the
-qoption, the script will read all required information from the
You can use the
-doption to run the script in "dry" mode. Running the script in dry mode causes the script to generate a database script.
python dba_script.py -d /tmp/generated-script.sql
Anyone can run the script, but it is recommended that the system DBA run the script in dry mode. In either case, the system DBA should review the generated script, but should only make minor adjustments to the script, for example, change the location of a particular database file. No major changes should be made that substantially alter the script -- otherwise the Ranger install may fail.
The system DBA must then run the generated script.
- Run the Ranger Ambari install procedure, but set Setup Database and Database User to No in the Ranger Admin section of the Customize Services page.