Content of pg_class.relacl

From: "Ed Brown" <ebrown(at)computer-systems(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Content of pg_class.relacl
Date: 2006-08-25 13:25:34
Message-ID: 457C5811B5F0244B9CB13119E027F7640DA373@CSISERV1.CSIIndy.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
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?

Thanks in advance for any replies.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-08-25 13:37:25 Re: Help needed defining timestamp format for input?
Previous Message Peter Eisentraut 2006-08-25 13:18:23 Re: Can I read data load files without loading in db?