Re: BUG #1161: User permissions are kept, even if user is

Поиск
Список
Период
Сортировка
От dd
Тема Re: BUG #1161: User permissions are kept, even if user is
Дата
Msg-id 40E51F6F.2010701@luch.podolsk.ru
обсуждение исходный текст
Ответ на Re: BUG #1161: User permissions are kept, even if user is  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #1161: User permissions are kept, even if user is
Список pgsql-bugs
little example of generating usesysid

    create user test sysid 2147483647;
CREATE USER
    create user test1;
CREATE USER
    select * from pg_shadow;
 usename  |  usesysid   | usecreatedb | usesuper | usecatupd | passwd |
valuntil | useconfig
----------+-------------+-------------+----------+-----------+--------+----------+-----------
 postgres |           1 | t           | t        | t         |
|          |
 test     |  2147483647 | f           | f        | f         |
|          |
 test1    | -2147483648 | f           | f        | f         |
|          |
(3 rows)

    create user test2;
psql:./tt:5: ERROR:  duplicate key violates unique constraint
"pg_shadow_usesysid_index"

And I have still a question:
How to remove privileges of the nonexistent (removed) user?
And the offer:
Can realize removal of privileges of nonexistent users during time vacuum?

PS: Sorry for my ugly english

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

Предыдущее
От: "PostgreSQL Bugs List"
Дата:
Сообщение: BUG #1186: Broken Index?
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: BUG #1161: User permissions are kept, even if user is