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 2021/06/24 13:15:25 UTC
Review Request 73434: RANGER-3322: remove grant of public synonym
privileges for oracle db flavor
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/73434/
-----------------------------------------------------------
Review request for ranger, Dhaval Shah, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Sailaja Polavarapu, Vishal Suvagia, and Velmurugan Periasamy.
Bugs: RANGER-3322
https://issues.apache.org/jira/browse/RANGER-3322
Repository: ranger
Description
-------
Since RANGER-3184 already has removed audit to DB references, the public synonym grant from the db script can also be removed as its related to access audit to db only and do not have any dependency on any other ranger db tables(other than xa_access_audit)
Note: During testing of this patch found few identifier name more than 30 character which is not allowed in oracle 11G, so have trimmed the name of index/identifier.
Diffs
-----
kms/scripts/dba_script.py c399de680
security-admin/db/oracle/optimized/current/ranger_core_db_oracle.sql e92f5cc48
security-admin/db/oracle/patches/052-add-unique-constraint-on-change-logs.sql 8c0672074
security-admin/db/oracle/xa_audit_db_oracle.sql 67a99be22
security-admin/scripts/dba_script.py 87ef88e3e
Diff: https://reviews.apache.org/r/73434/diff/1/
Testing
-------
Thanks,
Pradeep Agrawal
Re: Review Request 73434: RANGER-3322: remove grant of public synonym
privileges for oracle db flavor
Posted by Mehul Parikh <xs...@gmail.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/73434/#review223216
-----------------------------------------------------------
Ship it!
Ship It!
- Mehul Parikh
On June 30, 2021, 8:14 a.m., Pradeep Agrawal wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/73434/
> -----------------------------------------------------------
>
> (Updated June 30, 2021, 8:14 a.m.)
>
>
> Review request for ranger, Dhaval Shah, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Sailaja Polavarapu, Vishal Suvagia, and Velmurugan Periasamy.
>
>
> Bugs: RANGER-3322
> https://issues.apache.org/jira/browse/RANGER-3322
>
>
> Repository: ranger
>
>
> Description
> -------
>
> Since RANGER-3184 already has removed audit to DB references, the public synonym grant from the db script can also be removed as its related to access audit to db only and do not have any dependency on any other ranger db tables(other than xa_access_audit)
>
>
> Diffs
> -----
>
> kms/scripts/dba_script.py c399de680
> security-admin/db/oracle/xa_audit_db_oracle.sql 67a99be22
> security-admin/scripts/dba_script.py 87ef88e3e
>
>
> Diff: https://reviews.apache.org/r/73434/diff/2/
>
>
> Testing
> -------
>
> Test fresh installation for Oracle DB flavor.
> Tested upgrade case from 2.1 to 3.0 for oracle DB flavor.
>
>
> Thanks,
>
> Pradeep Agrawal
>
>
Re: Review Request 73434: RANGER-3322: remove grant of public synonym
privileges for oracle db flavor
Posted by Pradeep Agrawal <pr...@gmail.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/73434/
-----------------------------------------------------------
(Updated June 30, 2021, 8:14 a.m.)
Review request for ranger, Dhaval Shah, Abhay Kulkarni, Madhan Neethiraj, Mehul Parikh, Ramesh Mani, Sailaja Polavarapu, Vishal Suvagia, and Velmurugan Periasamy.
Changes
-------
Update patch
Bugs: RANGER-3322
https://issues.apache.org/jira/browse/RANGER-3322
Repository: ranger
Description (updated)
-------
Since RANGER-3184 already has removed audit to DB references, the public synonym grant from the db script can also be removed as its related to access audit to db only and do not have any dependency on any other ranger db tables(other than xa_access_audit)
Diffs (updated)
-----
kms/scripts/dba_script.py c399de680
security-admin/db/oracle/xa_audit_db_oracle.sql 67a99be22
security-admin/scripts/dba_script.py 87ef88e3e
Diff: https://reviews.apache.org/r/73434/diff/2/
Changes: https://reviews.apache.org/r/73434/diff/1-2/
Testing
-------
Test fresh installation for Oracle DB flavor.
Tested upgrade case from 2.1 to 3.0 for oracle DB flavor.
Thanks,
Pradeep Agrawal