Re: Database Users and Permissions

On Wed, Jul 24, 2002 at 16:24:31 +0200,
Søren Neigaard <neigaard(at)e-box(dot)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.