Re: OT DBA type question - GRANT PRIVILEGE

From: "James B(dot) Byrne" <byrnejb(at)harte-lyne(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: OT DBA type question - GRANT PRIVILEGE
Date: 2011-12-09 17:13:59
Message-ID: 48034.216.185.71.25.1323450839.squirrel@webmail.harte-lyne.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, December 8, 2011 20:23, Craig Ringer wrote:
On Thu, December 8, 2011 17:28, Andy Colson wrote:

These are the only replies I received. Am I to conclude
that most of the people on the list do not use GRANT
PRIVILEGE to implement anything more than the minimal
authorization scheme required to obtain access for anyone?

Nil reports, as in: "Generally, we do not use PostgreSQL's
GRANT PRIVILEGE to implement detailed user ACLs", would be
most welcome. If instead you are using GRANT PRIVILEGE
and have not responded, a simple "We (often, occasionally,
seldom) use detailed GRANT PRIVILEGE based user ACLs" is
sufficient.

I really want to get a sense of how prevalent using GRANT
PRIVILEGE, beyond the minimum required, is. And this
seems like a very good place to discover it. Again, please
reply off-list if you wish.

--
*** E-Mail is NOT a SECURE channel ***
James B. Byrne mailto:ByrneJB(at)Harte-Lyne(dot)ca
Harte & Lyne Limited http://www.harte-lyne.ca
9 Brockley Drive vox: +1 905 561 1241
Hamilton, Ontario fax: +1 905 561 0757
Canada L8E 3C3

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James B. Byrne 2011-12-09 17:43:42 Re: OT DBA type question - GRANT PRIVILEGE
Previous Message Tom Lane 2011-12-09 17:05:57 Re: Why is cast array integer[] <--> text[] is not immutable.