You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by Kirby Zhou <ki...@gmail.com> on 2022/10/04 01:55:03 UTC
Re: Review Request 74136: RANGER-3685:hive 'show' sql produces excessive audit log
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/74136/#review224738
-----------------------------------------------------------
Ship it!
Ship It!
- Kirby Zhou
On 九月 24, 2022, 2:37 p.m., Xuze Yang wrote:
>
> -----------------------------------------------------------
> This is an automatically generated e-mail. To reply, visit:
> https://reviews.apache.org/r/74136/
> -----------------------------------------------------------
>
> (Updated 九月 24, 2022, 2:37 p.m.)
>
>
> Review request for ranger, Kirby Zhou, Abhay Kulkarni, and Madhan Neethiraj.
>
>
> Bugs: RANGER-3685
> https://issues.apache.org/jira/browse/RANGER-3685
>
>
> Repository: ranger
>
>
> Description
> -------
>
> hive show sql produces too many audit logs, which will flood valuable audit logs and take up a lot of storage resources. This patch aims to provide a configuration item to support simplified hive audit logging
>
>
> Diffs
> -----
>
> agents-common/src/main/java/org/apache/ranger/authorization/hadoop/constants/RangerHadoopConstants.java 6675125e1
> hive-agent/src/main/java/org/apache/ranger/authorization/hive/authorizer/RangerHiveAuthorizer.java 8f6801be1
>
>
> Diff: https://reviews.apache.org/r/74136/diff/1/
>
>
> Testing
> -------
>
> 1. when configuration "xasecure.hive.simplify.audit.of.hive.show.sql" is not set or set to false. The code behaves the same as before,i.e record audit logs for each databases or tables
> 2. when configuration "xasecure.hive.simplify.audit.of.hive.show.sql" is set to true. It will only record an audit log about USE operation
>
>
> Thanks,
>
> Xuze Yang
>
>