-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72397/
-----------------------------------------------------------
Review request for ranger, Ankita Sinha, Dhaval Shah, Dineshkumar Yadav, Gautam
Borad, Jayendra Parab, Kishor Gollapalliwar, Abhay Kulkarni, Madhan Neethiraj,
Mehul Parikh, Nitin Galave, Nixon Rodrigues, Ramesh Mani, Sailaja Polavarapu,
and Velmurugan Periasamy.
Bugs: RANGER-2803
https://issues.apache.org/jira/browse/RANGER-2803
Repository: ranger
Description
-------
**Problem statement:** Modify db_setup.py script to handle pre-created user's
tablespace and tablespace name is not exposed to users who install ranger in
case of Oracle db flavor. If user will not be able to provide the
db_name/tablespace name then ranger setup may fail for him though its not his
fault.
**Proposed solution:** if db_name is not given then ranger setup script should
detect ranger db user default tablespace and continue the schema creation there.
Diffs
-----
kms/scripts/db_setup.py b68ff5c24
security-admin/scripts/db_setup.py e16d15ebc
Diff: https://reviews.apache.org/r/72397/diff/1/
Testing
-------
Created Ranger DB tablespace and users manually by using following commands :
1) create user $user 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 $user;
3) create $tablespace $tablespace datafile '$tablespace.dat' size 10M
autoextend on;
4) alter user $user DEFAULT tablespace $tablespace;
executed db_setup.py with db_name value as blank.
Thanks,
Pradeep Agrawal