Re: Database Users and Permissions - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: Database Users and Permissions
Date
Msg-id 20020724161523.GA30928@wolff.to
Whole thread Raw
In response to Database Users and Permissions  (Søren Neigaard <neigaard@e-box.dk>)
List pgsql-novice
On Wed, Jul 24, 2002 at 16:24:31 +0200,
  Søren Neigaard <neigaard@e-box.dk> wrote:
> I have tried this question twice before, but with no success. Maybe
> I'm asking the wrong question, or maybe I'm asking the question
> wrongly. I'm hoping it was the latter, and trying to rephrase.
>
> If you have a number of databases (on the same machine) and a number
> of users. Some users must connect to some databases, and others must
> connect to other databases. What is the smartest way of managing this?
> As I see it, I can't give a user group access to a database, or even a
> user. I can only give the user/group access on tabel level, not at
> database level. How do you guys do it?

This will be easy in 7.3. You will be able to limit users by group,
individually or by being listed in a file.

In 7.2 you might be able to do something suitable using ident authentication
and using different maps for different databases.

pgsql-novice by date:

Previous
From: Jeffrey Trueblood
Date:
Subject: Migration from MSSQL to PGSQL
Next
From: Ewald Geschwinde
Date:
Subject: Re: Migration from MSSQL to PGSQL