BUG #6350: Delete a role which is still in use

Поиск
Список
Период
Сортировка
От marc@msys.ch
Тема BUG #6350: Delete a role which is still in use
Дата
Msg-id E1RdP5d-0008TM-4r@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #6350: Delete a role which is still in use  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6350
Logged by:          Marc Balmer
Email address:      marc@msys.ch
PostgreSQL version: 9.1.1
Operating system:   NetBSD
Description:=20=20=20=20=20=20=20=20

A role can be deleted although it is still referenced in a column privilege.
 Here is how:

create three new roles:

user, admin, new_admin

create a table, e.g. "bar" with one column, e.g. "foo", owner of the table
is "admin".

now grant "user" select rights on the "foo" column in table "bar".

now change the owner of the table "bar" to "new_admin".

drop the role "admin".  PostgreSQL won't complain.

look at the privileges of table "bar" using \dp.  The ownership change from
"admin" to "new_admin" did not make it to the column privileges.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: BUG #6348: PROBLEMAS DELETE
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: BUG #6349: Cannot install on 32 bit platform