Postgres Pro
Downloads
Home   >   mailing lists

Re: The same role for multiple databases - Mailing list pgsql-admin

From Steven Chang
Subject Re: The same role for multiple databases
Date
Msg-id CAEJt7k2eA9bR3YCxKaBdgTHHJQPe4bLRnu3_V20N=wqqGaZ9_w@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] The same role for multiple databases  (John Scalia <jayknowsunix@gmail.com>)
List pgsql-admin
Tree view
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@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






pgsql-admin by date:

Previous
From: Steven Chang
Date:
Subject: Re: Best system for a data warehouse application
Next
From: gleeco
Date:
Subject: is replication effected by exclusive locks?