bug in permission handling?

Поиск
Список
Период
Сортировка
От Martin Renters
Тема bug in permission handling?
Дата
Msg-id 20020111141046.B3070@aspen.datafax.com
обсуждение исходный текст
Ответы Re: bug in permission handling?
Список pgsql-hackers
Should the permissions of a deleted user get assigned to a new user
as in the example below?

Martin

$ createdb test
CREATE DATABASE
$ psql test
Welcome to psql, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms      \h for help with SQL commands      \? for help on internal slash commands
    \g or terminate with semicolon to execute query      \q to quit
 

test=# create table abc(a int, b int);
CREATE
test=# select relacl from pg_class where relname='abc';relacl 
--------
(1 row)

test=# create user martin;
CREATE USER
test=# grant all on abc to martin;
GRANT
test=# select relacl from pg_class where relname='abc';              relacl                
-------------------------------------{=,postgres=arwdRxt,martin=arwdRxt}
(1 row)

test=# drop user martin;
DROP USER
test=# select relacl from pg_class where relname='abc';             relacl              
----------------------------------{=,postgres=arwdRxt,101=arwdRxt}
(1 row)

test=# create user tom;
CREATE USER
test=# select relacl from pg_class where relname='abc';             relacl              
----------------------------------{=,postgres=arwdRxt,tom=arwdRxt}
(1 row)

test=# select version();                              version                               
---------------------------------------------------------------------PostgreSQL 7.2b4 on i386-unknown-freebsd4.3,
compiledby GCC 2.95.3
 
(1 row)

test=# 



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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: checkpoint hang in 7.2b4
Следующее
От: Bear Giles
Дата:
Сообщение: Announcement: libpkixpq 0.4 (pkix + strong crypto for db)