You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ASF subversion and git services (JIRA)" <ji...@apache.org> on 2019/03/23 23:39:00 UTC
[jira] [Commented] (IMPALA-6988) Implement ALTER TABLE/VIEW SET
OWNER
[ https://issues.apache.org/jira/browse/IMPALA-6988?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16799844#comment-16799844 ]
ASF subversion and git services commented on IMPALA-6988:
---------------------------------------------------------
Commit 44da27816ac6f88fdb814a2d1c1f416411c95452 in impala's branch refs/heads/2.x from Fredy Wijaya
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=44da278 ]
IMPALA-6988: Implement ALTER TABLE/VIEW SET OWNER
Alter the table/view owner to either user or role.
On table/view creation, the table/view owner will be set to
the current user, which can be viewed via DESCRIBE FORMATTED
command. Having an owner information allows implementing a
feature where an owner can be given certain privileges
automatically upon a table/view creation. See IMPALA-7075.
The ALTER TABLE/VIEW SET OWNER will be useful commands for
transferring ownership (a set of owner privileges) from the
current owner to another owner.
Syntax:
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
Testing:
- Added new FE tests
- Added new E2E tests
Change-Id: Ia1b75b1590b16eb0c2ba326d07ee3fd9897c27d1
Reviewed-on: http://gerrit.cloudera.org:8080/10822
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>
Reviewed-on: http://gerrit.cloudera.org:8080/12799
Reviewed-by: Fredy Wijaya <fw...@cloudera.com>
> Implement ALTER TABLE/VIEW SET OWNER
> ------------------------------------
>
> Key: IMPALA-6988
> URL: https://issues.apache.org/jira/browse/IMPALA-6988
> Project: IMPALA
> Issue Type: Sub-task
> Components: Frontend
> Affects Versions: Impala 3.0, Impala 2.13.0
> Reporter: Adam Holley
> Assignee: Fredy Wijaya
> Priority: Major
> Labels: security
> Fix For: Impala 3.1.0
>
>
> Create statement to allow setting owner.
> {noformat}
> 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;{noformat}
> Examples:
> {noformat}
> 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>
> {noformat}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org