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

Reply via email to