Is there a workaround for using sysadmin privileges when using Oracle as the metastore during a Ranger install??

[#1]

When installing Ranger in a production environment we do not have access to sysadmin privileges. Is there anyway to install Ranger without using sysadmin?

[#2 · Accepted solution]

@Scott Shaw

Please see this link

I don't believe so. You would need a DBA to create user scheme and grant necessary privileges

You can use the Oracle root user to create the Ranger databases.

Optionally, you can also create a non-root user to use to create the Ranger databases. For example, you would use the following series of commands to create the RANGERDBA user and grant it permissions using SQL*Plus, the Oracle database administration utility:

# sqlplus sys/root as sysdba
CREATE USER $RANGERDBA IDENTIFIED BY $RANGERDBAPASSWORD; 
GRANT SELECT_CATALOG_ROLE TO $RANGERDBA;
GRANT CONNECT, RESOURCE TO $RANGERDBA; 
QUIT;