[EMAIL PROTECTED] writes:
> I was initially thinking, there 'should' be some way to limit the access
> in the desired way. So now I know, there is not.
Well, if you were using 8.2 then the CONNECT privilege would help...
regards, tom lane
---(end o
> Thomas Mack wrote:
>> Hello!
>>
>> I face a problem here with restricting access to databases to
>> the owners of the database (Postgres 8.1.4).
>>
>> We would like any postgres user to have database access restricted
>> to their own databases only. This is so, as we use postgres for
>> education
Hello,
I'm not sure why wish not to pre-create a database for each student
and limiting them to that database with the no create database priv.
Depending on why you want to do that, I think you might be able to
give each user a schema. I think access to schemas has to be
explicitly gran
Thomas Mack wrote:
Hello!
I face a problem here with restricting access to databases to
the owners of the database (Postgres 8.1.4).
We would like any postgres user to have database access restricted
to their own databases only. This is so, as we use postgres for
educational purposes.
I looked
Am Donnerstag, 24. Mai 2007 15:57 schrieben Sie:
> Thomas Mack wrote:
> > Hello!
> >
> > I face a problem here with restricting access to databases to
> > the owners of the database (Postgres 8.1.4).
> >
> > We would like any postgres user to have database access restricted
> > to their own databas
Thomas Mack wrote:
> Hello!
>
> I face a problem here with restricting access to databases to
> the owners of the database (Postgres 8.1.4).
>
> We would like any postgres user to have database access restricted
> to their own databases only. This is so, as we use postgres for
> educational purpo