[jira] [Commented] (SENTRY-2429) Transfer database owner drops table owner

["Hadoop QA (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/SENTRY-2429?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16656066#comment-16656066 ] 

Hadoop QA commented on SENTRY-2429:
-----------------------------------

Here are the results of testing the latest attachment
https://issues.apache.org/jira/secure/attachment/12944616/SENTRY-2429.001.patch against master.

{color:green}Overall:{color} +1 all checks pass

{color:green}SUCCESS:{color} all tests passed

Console output: https://builds.apache.org/job/PreCommit-SENTRY-Build/4184/console

This message is automatically generated.

> Transfer database owner drops table owner
> -----------------------------------------
>
>                 Key: SENTRY-2429
>                 URL: https://issues.apache.org/jira/browse/SENTRY-2429
>             Project: Sentry
>          Issue Type: Bug
>          Components: Sentry
>    Affects Versions: 2.1.0, 2.2.0
>            Reporter: Na Li
>            Assignee: Na Li
>            Priority: Major
>         Attachments: SENTRY-2429.001.patch
>
>
> 1) What is the problem?
> When changing owner of a database, the owners of all tables belonging to this database are removed.
> 2) For example:
> 2.1) user_A is owner of DB1, user_B is owner of DB1.TABLE1, and user_D is owner of DB1.TABLE2.
> 2.2) admin with" ALL with grant option" changes the owner of DB1 from user_A to user_C through command "ALTER DATABASE DB1 SET OWNER USER user_C".
> 2.3) Now, user_C is owner of DB1, there is no owner on DB1.TABLE1, and no owner on DB1.TABLE2.. In other words, the owners of DB1.TABLE1 and DB1.TABLE2 are removed when changing owner of their database.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)