Re: Bogus permissions display in 7.4 - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Bogus permissions display in 7.4
Date
Msg-id 200405141626.i4EGQWT10022@candle.pha.pa.us
Whole thread Raw
In response to Re: Bogus permissions display in 7.4  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Bogus permissions display in 7.4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Basically our whole API of communicating ACL information to the user is
poor.  Look at psql \z:
test=> create table test(x int);CREATE TABLEtest=> grant all on test to public;GRANTtest=> \z test
Accessprivileges for database "test" Schema | Name | Type  |                  Access
privileges--------+------+-------+------------------------------------------------------public | test | table |
{postgres=a*r*w*d*R*x*t*/postgres,=arwdRxt/postgres}(1row)
 

Do we actually expect folks to understand that?  What use is \z really
then?  Sure, maybe we document it in the GRANT manual page, but that
hardly makes it readable on its own.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: invalid type internal size -1
Next
From: Tom Lane
Date:
Subject: Re: Bogus permissions display in 7.4