From: | Christophe Pettus <xof(at)thebuild(dot)com> |
---|---|
To: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Can't remove default permissions entry |
Date: | 2020-05-27 17:06:18 |
Message-ID: | 4BCE1557-F145-46C9-9410-C67CA7510105@thebuild.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On RDS (thus, no superuser) we are trying to drop a user. The only remaining item that the user owns is an "empty" default permissions entry, but we can't seem to get rid of it so that the user can be dropped:
I'm sure I'm missing something obvious!
Logged in as xyuser:
db=> \ddp+
Default access privileges
Owner | Schema | Type | Access privileges
------------+---------------+----------+--------------------------
xyuser | | table |
db=> ALTER DEFAULT PRIVILEGES FOR USER xyuser REVOKE ALL ON TABLES FROM xyuser;
ALTER DEFAULT PRIVILEGES
db=> \ddp+
Default access privileges
Owner | Schema | Type | Access privileges
------------+---------------+----------+--------------------------
xyuser | | table |
db=>
--
-- Christophe Pettus
xof(at)thebuild(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2020-05-27 17:29:54 | Re: suggestion the process to sync the data from PROD DB to Staging environment |
Previous Message | Karsten Hilbert | 2020-05-27 16:54:53 | Re: Suggestion to Monitoring Tool |