[ 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)