| From: | Dave Page <dpage(at)pgadmin(dot)org> |
|---|---|
| To: | Marcin Stępnicki <mstepnicki(at)gmail(dot)com> |
| Cc: | Gerhard Botha <gbotha(at)winder(dot)co(dot)za>, pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: Step by step and thorough pgadmin/postgresql documentation |
| Date: | 2009-03-05 09:12:15 |
| Message-ID: | 937d27e10903050112j1005c4bfjac21459d77eb2589@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
On Thu, Mar 5, 2009 at 9:05 AM, Marcin Stępnicki <mstepnicki(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2009-03-05 09:26:26 | Re: pgAdmin for Greenplum database? |
| Previous Message | Marcin Stępnicki | 2009-03-05 09:05:22 | Re: Step by step and thorough pgadmin/postgresql documentation |