Re: The same role for multiple databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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







[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux