Feedback-ID: i7269461c:Fastmail
Message-ID: <96d6885a-5e25-9ae8-4a1a-d7e557a5fe9c@mtneva.com>
Date: Mon, 28 Aug 2023 19:23:48 -0600
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.11.0
Content-Language: en-US
To: pgsql-general@lists.postgresql.org
From: Stuart McGraw <smcgraw@mtneva.com>
Subject: Restoring default privileges on objects
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/96d6885a-5e25-9ae8-4a1a-d7e557a5fe9c%40mtneva.com>
Precedence: bulk

Hello,

The Postgresql docs on object privileges,
   https://www.postgresql.org/docs/14/ddl-priv.html
say this in regard to the output of the psql \dp command:

   | If the “Access privileges” column is empty for a given object, it
   | means the object has default privileges (that is, its privileges
   | entry in the relevant system catalog is null). [...] The first GRANT
   | or REVOKE on an object will instantiate the default privileges
   | (producing, for example, miriam=arwdDxt/miriam) and then modify them
   | per the specified request.

If I've done a GRANT or REVOKE on some of the tables, how do I restore
the default privileges so that the “Access privileges” appears empty
again?  I re-granted what I think are the default privileges but the
"Access privileges" column for that table contains "user1=arwdDxt/user1"
rather than being blank.  This is Postgresql-14.

Thanks for any suggestions!