Due to limitations in Amazon RDS, the Ranger database user and tablespace must be created manually and the required privileges must be manually granted to the Ranger database user.

    1. Log in to the RDS Oracle Server from the master user account (created during RDS Oracle instance creation) and execute following commands:

      1. create user $rangerdbuser identified by password”;
      2. GRANT CREATE SESSION,CREATE PROCEDURE,CREATE TABLE,CREATE VIEW,CREATE SEQUENCE,CREATE PUBLIC SYNONYM,CREATE ANY SYNONYM,CREATE TRIGGER,UNLIMITED Tablespace TO $rangerdbuser;
      3. create tablespace $rangerdb datafile size 10M autoextend on;
      4. alter user $rangerdbuser DEFAULT Tablespace $rangerdb;

      Where $rangerdb is a actual Ranger database name (for example: ranger) and $rangerdbuser is Ranger database username (for example: rangeradmin).

    2. If you are using Ranger KMS, execute the following commands:

      1. create user $rangerdbuser identified by password”;
      2. GRANT CREATE SESSION,CREATE PROCEDURE,CREATE TABLE,CREATE VIEW,CREATE SEQUENCE,CREATE PUBLIC SYNONYM,CREATE ANY SYNONYM,CREATE TRIGGER,UNLIMITED Tablespace TO $rangerkmsuser;
      3. create tablespace $rangerkmsdb datafile size 10M autoextend on;
      4. alter user $rangerkmsuser DEFAULT Tablespace $rangerkmsdb;

      Where $rangerkmsdb is a actual Ranger database name (for example: rangerkms) and $rangerkmsuser is Ranger database username (for example: rangerkms).