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