sentry-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hadoop QA (JIRA)" <>
Subject [jira] [Commented] (SENTRY-2429) Transfer database owner drops table owner
Date Fri, 19 Oct 2018 00:05:00 GMT


Hadoop QA commented on SENTRY-2429:

Here are the results of testing the latest attachment against master.

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

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

Console output:

This message is automatically generated.

> Transfer database owner drops table owner
> -----------------------------------------
>                 Key: SENTRY-2429
>                 URL:
>             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

View raw message