Thread: Newbie question

Newbie question

From
David
Date:
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!!!

Re: Newbie question

From
Robert Treat
Date:
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