Re: [HACKERS] grant still broken - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Re: [HACKERS] grant still broken
Date
Msg-id Pine.NEB.3.96.980113235407.259F-100000@thelab.hub.org
Whole thread Raw
In response to Re: [HACKERS] grant still broken  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
On Tue, 13 Jan 1998, Bruce Momjian wrote:

> Gee, still works fine here under bsd/os 3.0.
>
>     #$ sql test
>     Welcome to the POSTGRESQL interactive sql monitor:
>       Please read the file COPYRIGHT for copyright terms of POSTGRESQL
>
>        type \? for help on slash commands
>        type \q to quit
>        type \g or terminate with semicolon to execute query
>      You are currently connected to the database: test
>
>     test=> create table a (id int4,url text);
>     CREATE
>     test=> insert into a values (1,'http://www.demon.co.uk/finder');
>     INSERT 143530 1
>     test=> grant all on a to public;
>     CHANGE
>     test=>

FreeBSD 3.0-CURRENT as of yesterday:

scrappy=> create table a (id int4,url text);
CREATE
scrappy=> insert into a values (1,'http://www.demon.co.uk/finder');
INSERT 143210 1
scrappy=> grant all on a to public;
CHANGE
scrappy=> \z

Database    = scrappy
 +------------------+----------------------------------------------------+
 |  Relation        |             Grant/Revoke Permissions               |
 +------------------+----------------------------------------------------+
 | a                | {"=arwR"}                                          |
 | testtable        |                                                    |
 +------------------+----------------------------------------------------+
scrappy=>

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org


pgsql-hackers by date:

Previous
From: darcy@druid.net (D'Arcy J.M. Cain)
Date:
Subject: Re: [HACKERS] Priviliges on tables and views
Next
From: todd brandys
Date:
Subject: Re: New pg_pwd patch and stuff