Re: [ADMIN] Role based database access

2007-05-24 Thread Tom Lane
[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

Re: [ADMIN] Role based database access

2007-05-24 Thread mack
> 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

Re: [ADMIN] Role based database access

2007-05-24 Thread Carol Walter
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

Re: [ADMIN] Role based database access

2007-05-24 Thread Scott Marlowe
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

Re: [ADMIN] Role based database access

2007-05-24 Thread Thomas Mack
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

Re: [ADMIN] Role based database access

2007-05-24 Thread Alvaro Herrera
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