Thread: Database Users and Permissions

Database Users and Permissions

From
Søren Neigaard
Date:
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?

--
Med venlig hilsen/Best regards,
 Søren Neigaard mailto:neigaard@e-box.dk
--
 "Beware of bugs in the above code; I have only proved it correct, not tried it."


Re: Database Users and Permissions

From
Bruno Wolff III
Date:
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.