hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hison Huang (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-11899) No ADMIN PRIVILEGE need for creating and dropping temporary function.
Date Mon, 21 Sep 2015 07:54:04 GMT

     [ https://issues.apache.org/jira/browse/HIVE-11899?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Hison Huang updated HIVE-11899:
-------------------------------
    Attachment: HIVE-11899-01.patch

Solve the HIVE-11899 issue.

> No ADMIN PRIVILEGE need for creating and dropping temporary function.
> ---------------------------------------------------------------------
>
>                 Key: HIVE-11899
>                 URL: https://issues.apache.org/jira/browse/HIVE-11899
>             Project: Hive
>          Issue Type: Task
>          Components: SQLStandardAuthorization
>    Affects Versions: 0.13.1, 1.1.0
>            Reporter: Hison Huang
>         Attachments: HIVE-11899-01.patch
>
>
> SQLStandardAuthorization require ADMIN PRIVILEGE need for creating and dropping temporary
function as the following:
> > create function example_add AS 'org.apache.hadoop.hive.contrib.udf.example.UDFExampleAdd';
> Error: Error while compiling statement: FAILED: HiveAccessControlException Permission
denied: Principal [name=admin, type=USER] does not have following privileges for operation
CREATEFUNCTION [[ADMIN PRIVILEGE] on Object [type=DATABASE, name=default], [ADMIN PRIVILEGE]
on Object [type=FUNCTION, name=default.example_add]] (state=42000,code=40000)
> > drop function example_add;
> Error: Error while compiling statement: FAILED: HiveAccessControlException Permission
denied: Principal [name=admin, type=USER] does not have following privileges for operation
DROPFUNCTION [[ADMIN PRIVILEGE] on Object [type=DATABASE, name=default], [ADMIN PRIVILEGE]
on Object [type=FUNCTION, name=default.example_add]] (state=42000,code=40000)
> But we think it is unnecessary to create and drop temporary function. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message