Re: Content of pg_class.relacl

On Fri, Aug 25, 2006 at 09:25:34AM -0400, Ed Brown wrote:
> Can someone tell me how the content of the "relacl" column of the
> "pg_class" system table is interpreted? The documentation simply states
> "Access permissions. See the descriptions of GRANT and REVOKE for
> details." Much of the content of this column is obvious from the GRANT
> description - "r" = SELECT, "a" = INSERT, etc. But, there are other
> parts of the content that are not described. For example, there are
> asterisks in the permissions string for some users. These appear to
> represent permission with grant option, is this correct? I also can't

The GRANT documentation says

* -- grant option for preceding privilege

> find any information on the data following the slash. For example, in
> the "relacl" value "testuser=arwdRxt/csi", what does the "/csi"
> represent? Is this the owner of the table? The grantor? Is this
> discussed anywhere in the PostgreSQL documentation?

The GRANT documentation says

/yyyy -- user who granted this privilege

Did you overlook those or did you see them and have questions about
what they mean?

--
Michael Fuhr