Re: Using LDAP for PostgreSQL permissions/authentication

Поиск
Список
Период
Сортировка
От Bill Moran
Тема Re: Using LDAP for PostgreSQL permissions/authentication
Дата
Msg-id 20130913194604.8b2bfaf9daede4780cf1f8ea@potentialtech.com
обсуждение исходный текст
Ответ на Re: Using LDAP for PostgreSQL permissions/authentication  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-general
On Fri, 13 Sep 2013 16:29:47 -0400 Stephen Frost <sfrost@snowman.net> wrote:
>
> > Thus, when I go to log in as wmoran, LDAP checks my password, then informs
> > PostgreSQL to allow me in with specified roles, and I can do operations
> > granted to those roles.
>
> That's a little over-simplistic, isn't it?  What about objects which are
> created by the 'wmoran' account?

To address this one question, it's not terribly difficult to make a rule that
handles this.  LDAP could have a "primaryDatabaseRole" attribute that is used
when a single role is required (such as for object ownership) ... that's just
one possibility.


--
Bill Moran <wmoran@potentialtech.com>


В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: How to restore some DBs to a new server?
Следующее
От: Chris Travers
Дата:
Сообщение: Re: Best way to populate nested composite type from JSON`