From: | Michael Fuhr <mike(at)fuhr(dot)org> |
---|---|
To: | Ed Brown <ebrown(at)computer-systems(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Content of pg_class.relacl |
Date: | 2006-08-26 20:21:18 |
Message-ID: | 20060826202118.GA46437@winnie.fuhr.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Bob Pawley | 2006-08-26 20:22:49 | Re: Inserting Data |
Previous Message | Jim | 2006-08-26 20:16:40 | Fwd: Can't populate database using Copy |