[IMPALA-6988] Implement ALTER TABLE/VIEW SET OWNER

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 3.0, Impala 2.13.0
• Fix Version/s: Impala 2.13.0, Impala 3.1.0
• Component/s: Frontend
• Labels: security
• Epic Color: ghx-label-5
• Assignee: Fredy Wijaya
• Reporter: Adam Holley
• Created: 08/May/18 17:29
• Updated: 26/Mar/19 01:49
• Resolved: 15/Jul/18 22:11

Description

Create statement to allow setting owner.

ALTER TABLE database_name.table_name SET OWNER [USER|ROLE] user_or_role;
ALTER VIEW database_name.view_name SET OWNER [USER|ROLE] user_or_role;

Examples:

ALTER TABLE <table> SET OWNER USER <user>
ALTER TABLE <table> SET OWNER ROLE <role>

ALTER VIEW <view> SET OWNER USER <user>
ALTER VIEW <view> SET OWNER ROLE <role>

 

Issue Links

• relates to: IMPALA-7076 Impala 2.13 & 3.1 Docs: ALTER TABLE / VIEW SET OWNER