| 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: | Whole Thread | Raw Message | 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=#
| 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 |