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)