Re: [HACKERS] grant still broken

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(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org