Re: Re: grant privileges to a database [URGENT]

MySQL has this feature. I run a multi-user system and require shared MySQL
And PostgreSQL dbs. I have mysql fine. Users have their DBs and can only
access their DBs... but theres no real way to do this in Postgres. I can
restrict tables, but I can still create tables in other poeples DBs. Maybe
only allowed to acess DBs you create or are assigned permission to

--
Mike

>From: "Martin A. Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
>To: Michael Fork <mfork(at)toledolink(dot)com>
>CC: pgsql-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
>Subject: Re: Re: grant privileges to a database
>Date: Wed, 31 Jan 2001 16:41:59 -0300
>
>El Mi 31 Ene 2001 15:53, Michael Fork escribi:
> > This is the closest thing to what you want:
> >
> > GRANT ALL ON table TO user;
> >
> > (see http://www.postgresql.org/users-lounge/docs/7.0/user/sql-grant.htm)
>
>Yes, I'm aware of that. That's why I'm asking for an opinion of the
>developers on this issue.
>I think it would be a nice feature, so that the postgres user creates the
>database and gives all kind of permissions on that database to another
>user,
>which doesn't have to be able to create databases.
>
>Any comments?
>
>--
>System Administration: It's a dirty job,
>but someone told I had to do it.
>-----------------------------------------------------------------
>Martn Marqus email: martin(at)math(dot)unl(dot)edu(dot)ar
>Santa Fe - Argentina http://math.unl.edu.ar/~martin/
>Administrador de sistemas en math.unl.edu.ar
>-----------------------------------------------------------------

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.