From: | Stuart McGraw <smcgraw(at)mtneva(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Restoring default privileges on objects |
Date: | 2023-08-29 01:23:48 |
Message-ID: | 96d6885a-5e25-9ae8-4a1a-d7e557a5fe9c@mtneva.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Vinit Saini | 2023-08-29 05:16:58 | Postgres service is not starting |
Previous Message | Jerry Sievers | 2023-08-28 22:35:53 | Re: auto vacuum question |
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2023-08-29 01:43:46 | Re: Eager page freeze criteria clarification |
Previous Message | Tatsuo Ishii | 2023-08-29 01:04:24 | Re: Wrong usage of pqMsg_Close message code? |