[
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)
