Re: OT DBA type question - GRANT PRIVILEGE - Mailing list pgsql-general

From Scott Marlowe
Subject Re: OT DBA type question - GRANT PRIVILEGE
Date
Msg-id CAOR=d=195ZJAPGWgGOtvq0sqSg7JpZ5UrGjcobK5uwxjzQa1zQ@mail.gmail.com
Whole thread Raw
In response to Re: OT DBA type question - GRANT PRIVILEGE  ("James B. Byrne" <byrnejb@harte-lyne.ca>)
List pgsql-general
On Fri, Dec 9, 2011 at 10:43 AM, James B. Byrne <byrnejb@harte-lyne.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

pgsql-general by date:

Previous
From: "James B. Byrne"
Date:
Subject: Re: OT DBA type question - GRANT PRIVILEGE
Next
From: Rob Sargent
Date:
Subject: Is the a "magic number" for WAL files