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