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" <[EMAIL PROTECTED]>
>To: Michael Fork <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED], [EMAIL PROTECTED]
>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: [EMAIL PROTECTED]
>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.
