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@math.unl.edu.ar>
>To: Michael Fork <mfork@toledolink.com>
>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.