Обсуждение: Database Users and Permissions

Поиск
Список
Период
Сортировка

Database Users and Permissions

От
Søren Neigaard
Дата:
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

От
Bruno Wolff III
Дата:
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.