Re: BUG #6021: There is no difference between default and empty access privileges with \dp

On Thu, May 12, 2011 at 6:20 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "psql \dp showing empty Access privileges column for {}" <gszpetkowski@gm=
ail.com> writes:
>> Description: =A0 =A0 =A0 =A0There is no difference between default and e=
mpty access
>> privileges with \dp
>
> Yeah. =A0It's been like that since forever, and nobody's complained
> before, possibly because revoking all privileges for everybody isn't
> a particularly useful real-world case.
>
> One possibility is to start showing "default" when the ACL is null,
> which would be quite easy to implement:
>
> =A0 =A0 =A0 =A0COALESCE(array_to_string(c.relacl, E'\n'), 'default')
>
> But that might be too big a change.

I don't think that's too big a change.  ISTM we ought to change
something.  Another idea would be to always show the permissions, even
if nothing has been changed from the defaults.

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company