Re: DBA user in Postgres

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

 



On Wed, Nov 28, 2012 at 11:58 AM, Gabriel Muñoz <gabriel.munoz@xxxxxxxxx> wrote:
> As I can give you full permission to a user in a database. For everything
> you have that database and the objects to be created in the future.
> This means you can access all the schemes, all tables, views, functions,
> etc.
> If in the future you create a new view does not have to do a specific GRANT
> to that user since the user is the "owner" of the database.
>
> Try saying the user is super-user and restrict access only to the database
> from pg_hba. But being super-user can for example delete another database
> that is not theirs.

If the db owner is steve, and you want bob to be able to do anything
steve can do, you can do:

grant steve to bob;

Does that do what you need?


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