Hison Huang created HIVE-11899:
----------------------------------
Summary: 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: 1.1.0, 0.13.1
Reporter: Hison Huang
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)
