Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 90BD8475E64
	for <pgsql-admin@postgresql.org>; Tue, 14 Jan 2003 09:51:03 -0500 (EST)
Received: from localhost.localdomain (unknown [65.217.53.66])
	by postgresql.org (Postfix) with ESMTP id C74E447580B
	for <pgsql-admin@postgresql.org>; Tue, 14 Jan 2003 09:51:02 -0500 (EST)
Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100])
	by localhost.localdomain (8.12.5/8.12.5) with ESMTP id h0EF9F6P025029;
	Tue, 14 Jan 2003 10:09:16 -0500
Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55])
	by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h0EEolj23436;
	Tue, 14 Jan 2003 09:50:48 -0500
Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP
	(Microsoft Exchange Internet Mail Service Version 5.5.2653.13)
	id CWVLBC73; Tue, 14 Jan 2003 09:50:46 -0500
Subject: Re: Newbie question
From: Robert Treat <xzilla@users.sourceforge.net>
To: David <david@cnb.uam.es>
Cc: pgsql-admin@postgresql.org
In-Reply-To: <a05111b02ba49c9bbff34@[150.244.80.140]>
References: <a05111b02ba49c9bbff34@[150.244.80.140]>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8 
Date: 14 Jan 2003 09:50:46 -0500
Message-Id: <1042555846.24625.6.camel@camel>
Mime-Version: 1.0
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/147
X-Sequence-Number: 6989

On Tue, 2003-01-14 at 09:12, David wrote:
> How to grant a whole database for a certain user ?
> i mean:
> <mysql>
> grant usage on mydb.* to myuser identified by 'mypasswd'
> </mysql>
> Is available something similar with postgres or should i write a shell
> script, for example?
> Thank you very much!!!

You'll need to right a shell script or a server side function to do
this.  

BTW - some people have talked about adding this feature in the past, and
I think that if the code were submitted it wouldn't be rejected, but
AFAIK the SQL standard doesn't support setting the privileges on more
than one table per command so it is low priority for the main
development team.

Robert Treat