Replicating privileges from one user to another

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

 



I have user foo that is owner of database dbfoo. Now I need to create user baz that will have the exact same privileges as user foo on database baz. I've tried this:

GRANT ALL ON DATABASE dbfoo TO baz;

but I still can't select form tables.

Is there a easier way, or do I need to go trough all the tables/views/functions/schemas and issue GRANT ALL ON ... TO USER baz?

	Mario

--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[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