Re: OT DBA type question - GRANT PRIVILEGE

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: OT DBA type question - GRANT PRIVILEGE
Date: 2011-12-09 18:19:33
Message-ID: CAOR=d=195ZJAPGWgGOtvq0sqSg7JpZ5UrGjcobK5uwxjzQa1zQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Dec 9, 2011 at 10:43 AM, James B. Byrne <byrnejb(at)harte-lyne(dot)ca> wrote:
>
> On Fri, December 9, 2011 12:13, James B. Byrne wrote:
>
> Just to clarify the question.  What I am asking basically
> comes down to if separate user ids are added for most
> individuals that access the database or not.

Most of the time I create a role, grant / revoke privileges there, and
then grant that role to individuals as needed. I almost never grant /
revoke privileges to an individual

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2011-12-09 18:46:06 Is the a "magic number" for WAL files
Previous Message Andrew Sullivan 2011-12-09 18:01:35 Re: OT DBA type question - GRANT PRIVILEGE