From: | Poul Kristensen <bcc5226(at)gmail(dot)com> |
---|---|
To: | John Scalia <jayknowsunix(at)gmail(dot)com> |
Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: The same role for multiple databases |
Date: | 2017-03-13 09:30:33 |
Message-ID: | CAAOuvVo7bZ5-b3ZrVULi4iAjcACSE8W9c-8r0TUT7rhJ3xdN8A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gmail(dot)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(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | John Scalia | 2017-03-13 11:59:20 | Re: The same role for multiple databases |
Previous Message | John Scalia | 2017-03-10 15:17:58 | Re: The same role for multiple databases |