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@hub.org           secondary: scrappy@{freebsd|postgresql}.org