Re: Step by step and thorough pgadmin/postgresql documentation - Mailing list pgadmin-support

From Dave Page
Subject Re: Step by step and thorough pgadmin/postgresql documentation
Date
Msg-id 937d27e10903050112j1005c4bfjac21459d77eb2589@mail.gmail.com
Whole thread Raw
In response to Re: Step by step and thorough pgadmin/postgresql documentation  (Marcin Stępnicki <mstepnicki@gmail.com>)
Responses Re: Step by step and thorough pgadmin/postgresql documentation
List pgadmin-support
On Thu, Mar 5, 2009 at 9:05 AM, Marcin Stępnicki <mstepnicki@gmail.com> wrote:

> Go to File/Options/Preferences and turn on "Show users for
> privileges". This should be default in my opinion.

No it shouldn't. In most cases if you're configuring permissions for
individual users then you're setting yourself up for future pain and
suffering.

Setup your permissions for group roles, and then add user roles to
those groups. Then if you have staff turnover, or decide you want to
use different user accounts for each of your webservers that access
the database or whatever, instead of having to recreate a complex set
of permissions for each new user, you simply add them to the
appropriate groups.


--
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com


pgadmin-support by date:

Previous
From: Marcin Stępnicki
Date:
Subject: Re: Step by step and thorough pgadmin/postgresql documentation
Next
From: woodcock
Date:
Subject: easy enabling of debugging on Windows?