[HIVE-6252] sql std auth - support 'with admin option' in revoke role metastore api

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.14.0
• Component/s: Authorization, SQLStandardAuthorization
• Labels: TODOC14

Release Note

Adds support for "ADMIN OPTION FOR" in revoke role.
It lets you revoke the ADMIN OPTION of a user on a role. The user remains a member of that role.
eg -
revoke admin option for src_role_wadmin from user user2;

• Assignee: Jason Dere
• Reporter: Thejas Nair
• Created: 21/Jan/14 23:04
• Updated: 13/Nov/14 19:44
• Resolved: 12/Jul/14 02:00

Description

The metastore api for revoking role privileges does not accept 'with admin option' , though the syntax supports it. SQL syntax also supports grantor specification in revoke role statement.

It should be similar to the grant_role api.

Issue Links

• is duplicated by: HIVE-6253 sql std auth - revoke role should support sql standard syntax for admin option
• is related to: HIVE-7404 Revoke privilege should support revoking of grant option
• links to: https://reviews.apache.org/r/23373