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

SQLShaw — Tue, 03 Nov 2015 05:41:04 GMT

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

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

nsabharwal — Tue, 03 Nov 2015 05:45:45 GMT

@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;

question Re: Is there a workaround for using sysadmin privileges when using Oracle as the metastore during a Ranger install?? in Archives of Support Questions (Read Only)

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

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