[
https://issues.apache.org/jira/browse/SENTRY-2429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Na Li updated SENTRY-2429:
--------------------------
Description:
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.
was:
If user_A is the owner of database and one of the tables in the same database,
user_A is not owner of that table after "alter database set owner" command.
> 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
>
> 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)
