You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by Pradeep Agrawal <pr...@gmail.com> on 2020/04/21 12:31:05 UTC
Review Request 72397: RANGER-2803: Modify db_setup.py script to handle
pre-created user's tablespace for Oracle
-----------------------------------------------------------
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
Re: Review Request 72397: RANGER-2803: Modify db_setup.py script to
handle pre-created user's tablespace for Oracle
Posted by Mehul Parikh <xs...@gmail.com>.
-----------------------------------------------------------
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
>
>