[
https://issues.apache.org/jira/browse/HIVE-12704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15062625#comment-15062625
]
Thejas M Nair commented on HIVE-12704:
--------------------------------------
What is hive.security.authorization.manager set to ?
Seems like you are using the broken old authorization mode, the reccomended
alternative is
https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+based+hive+authorization
(for hiveserver2 use cases).
> Hive default authorization does not allow cross-database create table
> ---------------------------------------------------------------------
>
> Key: HIVE-12704
> URL: https://issues.apache.org/jira/browse/HIVE-12704
> Project: Hive
> Issue Type: Bug
> Components: Authorization
> Affects Versions: 1.2.1
> Reporter: Jonathan Hseu
> Assignee: Thejas M Nair
>
> hive> use default;
> OK
> hive> create table jhseu.test_table1 (a int);
> Authorization failed:No privilege 'Create' found for outputs {
> database:default}. Use SHOW GRANT to get more details.
> 15/12/17 16:26:09 ERROR ql.Driver: Authorization failed:No privilege 'Create'
> found for outputs { database:default}. Use SHOW GRANT to get more details.
> hive> use jhseu;
> OK
> hive> create table jhseu.test_table1 (a int);
> OK
> Create table authorization checks against the table you're currently using,
> but it only should check against the destination.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
