Postgres Pro
Downloads
Home   >   mailing lists

DBA user in Postgres - Mailing list pgsql-admin

From Gabriel Muñoz
Subject DBA user in Postgres
Date
Msg-id CAP8pxBZ03TcQQTbq9bt4fFQHnJK_MifBOQzpvdBcgDvHXMDstA@mail.gmail.com
Whole thread Raw
Responses Re: DBA user in Postgres
List pgsql-admin
Tree view
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.

Thank you very much,
Gabriel.

pgsql-admin by date:

Previous
From: Gabriel Muñoz
Date:
Subject: Re: NEED REPLICATION SOLUTION -POSTGRES 9.1
Next
From: Steve Crawford
Date:
Subject: Re: Fwd: Monitoring Replication on Master/Slave Postgres(9.1)