[
https://issues.apache.org/jira/browse/IMPALA-7016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16769944#comment-16769944
]
ASF subversion and git services commented on IMPALA-7016:
---------------------------------------------------------
Commit 1a2ea50fe83c8fc14e87f948ecf1997123941804 in impala's branch
refs/heads/2.x from Fredy Wijaya
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=1a2ea50 ]
IMPALA-7016: Implement ALTER DATABASE SET OWNER
Alter the database owner to either user or role.
On database creation, the database owner will be set to the current
user, which can be viewed via DESCRIBE DATABASE db command. Having an
owner information allows implementing a feature where an owner can be
given certain privileges automatically upon a database creation. See
IMPALA-7075. The ALTER DATABASE SET OWNER will be a useful command for
transferring ownership (a set of owner privileges) from the current
owner to another owner.
Syntax:
ALTER DATABASE db SET OWNER USER user
ALTER DATABASE db SET OWNER ROLE role
Testing:
- Added new front-end tests
- Added new end-to-end tests
Change-Id: Ie3b923021ebce5192d2d64784e7ddb952ba82bc3
Reviewed-on: http://gerrit.cloudera.org:8080/10471
Reviewed-by: Impala Public Jenkins <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>
> Implement ALTER DATABASE SET OWNER
> ----------------------------------
>
> Key: IMPALA-7016
> URL: https://issues.apache.org/jira/browse/IMPALA-7016
> 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 2.13.0, Impala 3.1.0
>
>
> Create statement to allow setting owner on database
> {noformat}
> ALTER DATABASE database_name SET OWNER [USER|ROLE] user_or_role;{noformat}
> Examples:
> {noformat}
> ALTER DATABASE <db> SET OWNER USER <user>
> ALTER DATABASE <db> SET OWNER ROLE <role>
> {noformat}
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
