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 по дате отправления: