As of Sentry 1.6, the database storage model is the preferred method for storing privileges and roles. When you configure Sentry to use the database storage model, it also includes a service that is managed by Warden. The following databases can be used to store privileges and roles: MySQL, Oracle, Postgres, DB2 and Derby. Examples in the following procedure use MySQL as the database type.
When you install Sentry with the MapR Installer and you specify MySQL as the database for Sentry, the MapR Installer performs the following configurations.
Create a database for Sentry.
For example, run the following commands to create a MySQL database:
In sentry-site.xml file (/opt/mapr/sentry/sentry-<version>/conf/sentry-site.xml), update the value of the following property:
Set the value to
In the sentry-site.xml file (/opt/mapr/sentry/sentry-<version>/conf/sentry-site.xml), add the following properties:
Set the value to the JDBC connection URL.
Set the value to the Backend JDBC driver.
Set the value to the JDBC user name.
Set the value to the JDBC password.
Initialize the database schema.