[ https://issues.apache.org/jira/browse/SENTRY-2308?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16581718#comment-16581718 ]
Hadoop QA commented on SENTRY-2308: ----------------------------------- Here are the results of testing the latest attachment https://issues.apache.org/jira/secure/attachment/12935743/SENTRY-2308.4.patch against master. {color:green}Overall:{color} +1 all checks pass {color:green}SUCCESS:{color} all tests passed Console output: https://builds.apache.org/job/PreCommit-SENTRY-Build/4028/console This message is automatically generated. > Create privilege on table has no use case > ----------------------------------------- > > Key: SENTRY-2308 > URL: https://issues.apache.org/jira/browse/SENTRY-2308 > Project: Sentry > Issue Type: Bug > Components: Sentry > Affects Versions: 2.1.0 > Reporter: Sergio Peña > Assignee: Sergio Peña > Priority: Major > Attachments: SENTRY-2308.1.patch, SENTRY-2308.2.patch, > SENTRY-2308.3.patch, SENTRY-2308.4.patch > > > Currently it is possible to grant CREATE on a table. However, there do not > seem to be any SQL operations that require this privilege. > For example, ALTER TABLE ADD PARTITION, requires ALTER and not CREATE. > Here is another example that requires INSERT on the target table, not CREATE > (or ALTER): > {noformat} > set hive.exec.dynamic.partition.mode=nonstrict;INSERT OVERWRITE TABLE > config1_test_database1.aliens PARTITION (home_planet, diet) SELECT name, > home_planet, diet FROM config1_test_database1.movie_stars WHERE home_planet > IS NOT NULL AND diet IS NOT NULL; > {noformat} > If there is no use case for granting CREATE on a table, we should considering > not allowing this operation. -- This message was sent by Atlassian JIRA (v7.6.3#76005)