Re: The same role for multiple databases

From: John Scalia <jayknowsunix(at)gmail(dot)com>
To: Poul Kristensen <bcc5226(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: The same role for multiple databases
Date: 2017-03-10 15:17:58
Message-ID: CABzCKRDiYTLgqTWoiHcT1zP+o-DFpVYOkw7cmFEc83oAb=ks4Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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
>
>
>
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Poul Kristensen 2017-03-13 09:30:33 Re: The same role for multiple databases
Previous Message Albe Laurenz 2017-03-10 14:32:53 Re: Too many WAL file created