-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/72397/#review220458
-----------------------------------------------------------


Ship it!




Ship It!

- Mehul Parikh


On April 21, 2020, 12:31 p.m., Pradeep Agrawal wrote:
> 
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/72397/
> -----------------------------------------------------------
> 
> (Updated April 21, 2020, 12:31 p.m.)
> 
> 
> 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/2/
> 
> 
> 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