[jira] [Commented] (SENTRY-2308) Create privilege on table has no use case

["Hadoop QA (JIRA)" <ji...@apache.org>]

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

Hadoop QA commented on SENTRY-2308:
-----------------------------------

Here are the results of testing the latest attachment
https://issues.apache.org/jira/secure/attachment/12931584/SENTRY-2308.3.patch against master.

{color:red}Overall:{color} -1 due to 4 errors

{color:red}ERROR:{color} mvn test exited 1
{color:red}ERROR:{color} Failed: org.apache.sentry.tests.e2e.hdfs.TestHDFSIntegrationTogglingConf
{color:red}ERROR:{color} Failed: org.apache.sentry.tests.e2e.hdfs.TestHDFSIntegrationEnd2End
{color:red}ERROR:{color} Failed: org.apache.sentry.tests.e2e.hdfs.TestHDFSIntegrationAdvanced

Console output: https://builds.apache.org/job/PreCommit-SENTRY-Build/4012/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
>
>
> 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)