[ https://issues.apache.org/jira/browse/HIVE-8067?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14131152#comment-14131152 ]
Lefty Leverenz commented on HIVE-8067: -------------------------------------- Agreed, and the description should list all the possible values. Patch 1 adds defaults INSERT, SELECT, UPDATE, and DELETE but the old description says 'An example like "select,drop" will grant select and drop privilege to the owner of the table' and the wiki lists DROP instead of DELETE. Is the wiki list complete and accurate? * ALL, ALTER, UPDATE, CREATE (irrelevant here), DROP, INDEX (not implemented), LOCK, SELECT, SHOW_DATABASE (irrelevant here) * [Hive Default Authorization (Legacy Mode) -- Privileges | https://cwiki.apache.org/confluence/display/Hive/Hive+Default+Authorization+-+Legacy+Mode#HiveDefaultAuthorization-LegacyMode-Privileges] > set default table permissions for table owner to have all privileges > -------------------------------------------------------------------- > > Key: HIVE-8067 > URL: https://issues.apache.org/jira/browse/HIVE-8067 > Project: Hive > Issue Type: Bug > Components: Authorization, SQLStandardAuthorization > Reporter: Thejas M Nair > Assignee: Thejas M Nair > Attachments: HIVE-8067.1.patch > > > When tables are created using without SQLStandards based authorization being > enabled, the table owner does not have any privileges on the table. > It makes sense to set the default privileges to be compatible with sql > standard mode's expected default privileges for the owner of the table, > instead of setting no privileges at all. -- This message was sent by Atlassian JIRA (v6.3.4#6332)