From: Robert Treat <xzilla@users.sourceforge.net>
To: David <david@cnb.uam.es>
Cc: pgsql-admin@postgresql.org
Subject: Re: Newbie question
Date: 14 Jan 2003 09:50:46 -0500
Message-ID: <1042555846.24625.6.camel@camel> (raw)
In-Reply-To: <a05111b02ba49c9bbff34@[150.244.80.140]>
References: <a05111b02ba49c9bbff34@[150.244.80.140]>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: xzilla@users.sourceforge.net, david@cnb.uam.es
Subject: Re: Newbie question
In-Reply-To: <1042555846.24625.6.camel@camel>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox