Re: The same role for multiple databases

[Steven Chang <stevenchang1213@xxxxxxxxx>]

hello Poul,

    Why not just create a super user ??

    User is also a role with login privilege.

    You can also grant "your superuser " to "other user" .

    It's more convenient.

Br,

Steven

2017-03-10 23:17 GMT+08:00 John Scalia <jayknowsunix@xxxxxxxxx>:

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