You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ranger.apache.org by "Siddhant Sontakke (Jira)" <ji...@apache.org> on 2023/05/18 14:43:00 UTC

[jira] [Commented] (RANGER-3451) Audits are not being generated for Hive "Alter table add constraint" commands

    [ https://issues.apache.org/jira/browse/RANGER-3451?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17723928#comment-17723928 ] 

Siddhant Sontakke commented on RANGER-3451:
-------------------------------------------

This issue is blocked by HIVE-27326. Once this is fixed, audits for alter queries will be generated automatically.

> Audits are not being generated for Hive "Alter table add constraint" commands
> -----------------------------------------------------------------------------
>
>                 Key: RANGER-3451
>                 URL: https://issues.apache.org/jira/browse/RANGER-3451
>             Project: Ranger
>          Issue Type: Bug
>          Components: Ranger
>            Reporter: Abhishek
>            Assignee: Siddhant Sontakke
>            Priority: Major
>
> Audits are not being generated for Hive "Alter table add constraint" commands.
> But audits are being generated for other "Alter table" commands.
> Steps to reproduce :-
>  # Create a policy in Hadoop SQL repo for hrt_qa user:-
> database-*, table - *, column - *, and allow all access to hrt_qa user.
>  # In beeline, run the following commands
> {code:java}
> Drop table if exists hr;
> Create table hr(c0 int);
> ALTER TABLE hr SET TBLPROPERTIES ('notes'="Please don't drop this table.");
> ALTER TABLE hr ADD CONSTRAINT unique_key_const UNIQUE (c0) DISABLE NOVALIDATE;{code}
> In Ranger Admin, audits are generated for the first 3 commands, but audits are not generated for the fourth command.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)