bug in permission handling?

From: Martin Renters <martin(at)datafax(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: bug in permission handling?
Date: 2002-01-11 19:10:46
Message-ID: 20020111141046.B3070@aspen.datafax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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, compiled by GCC 2.95.3
(1 row)

test=#

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Don Baccus 2002-01-11 19:29:32 Re: again on index usage
Previous Message Tom Lane 2002-01-11 19:09:21 Re: again on index usage