Re: Content of pg_class.relacl - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Content of pg_class.relacl
Date
Msg-id 20060826202118.GA46437@winnie.fuhr.org
Whole thread Raw
In response to Content of pg_class.relacl  ("Ed Brown" <ebrown@computer-systems.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Shared Objects (Dynamic loading)
Next
From: Douglas McNaught
Date:
Subject: Re: implementing a read lock