Re: [ADMIN] The same role for multiple databases

Поиск
Список
Период
Сортировка
От Poul Kristensen
Тема Re: [ADMIN] The same role for multiple databases
Дата
Msg-id CAAOuvVo7bZ5-b3ZrVULi4iAjcACSE8W9c-8r0TUT7rhJ3xdN8A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] The same role for multiple databases  (John Scalia <jayknowsunix@gmail.com>)
Ответы Re: [ADMIN] The same role for multiple databases
Список pgsql-admin
Дерево обсуждения
Thanks for fast responce.

Could this iteraction roles, schemas, databases  - e.g. configurations in pg_hba.conf -  between multiple databases and different Postgres minor version e.g. 9.6 to 9.6.1 cause trouble when upgrading still between minor versions? 
An if any potential problems would this be announced in release comments.

Thanks. 



  

2017-03-10 16:17 GMT+01:00 John Scalia <jayknowsunix@gmail.com>:
Yes, (or is that too glib?)

Roles are global in postgresql, so it's just a simple grant assignment.
--
Jay

On Fri, Mar 10, 2017 at 9:16 AM, Poul Kristensen <bcc5226@gmail.com> wrote:

Hi!

Is it possible to grant some priviliges for a role to multiple databases?

Just to illustrate:
grant all priviliges on database1 to role a. 
grant all priviliges on database2 to role a.


Thanks!

Poul








--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA

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

Предыдущее
От: John Scalia
Дата:
Сообщение: Re: [ADMIN] The same role for multiple databases
Следующее
От: John Scalia
Дата:
Сообщение: Re: [ADMIN] The same role for multiple databases