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" 
>To: Michael Fork 
>CC: pgsql-hackers@postgresql.org, pgsql-general@postgresql.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.
>-----------------------------------------------------------------
>Mart�n Marqu�s			email: 	martin@math.unl.edu.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.