DMARC-Filter: OpenDMARC Filter v1.3.2 mta-p5.oit.umn.edu 4W7Q2Y34PGz9vKZL
MIME-Version: 1.0
From: Matt Zagrabelny <mzagrabe@d.umn.edu>
Date: Mon, 24 Jun 2024 19:00:23 -0500
Message-ID: <CAOLfK3Wx2VMhNONFpNpnA0LCMXpQgmSadGicJ3K+LF+ayeTWxQ@mail.gmail.com>
Subject: schema privileges and drop role
To: "pgsql-general@postgresql.org >> PG-General Mailing List" <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000414f69061bab965e"
Archived-At: <https://www.postgresql.org/message-id/CAOLfK3Wx2VMhNONFpNpnA0LCMXpQgmSadGicJ3K%2BLF%2BayeTWxQ%40mail.gmail.com>
Precedence: bulk

--000000000000414f69061bab965e
Content-Type: text/plain; charset="UTF-8"

Greetings,

I have a database that I recently changed the ownership for and now I am
attempting to drop the previous owner of the database:

test_db=# drop ROLE legacy_owner;
ERROR:  role "legacy_owner" cannot be dropped because some objects depend
on it
DETAIL:  privileges for schema public

I don't know where to look to find out what I need to alter to be able to
remove the legacy role and internet searches came up fruitless.

Does anyone have any hints or advice on where to look?

Thanks for the help!

-m

--000000000000414f69061bab965e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Greetings,</div><div><br></div><div>I have a database=
 that I recently changed the ownership for and now I am attempting to drop =
the previous owner of the database:</div><div><br></div><div>test_db=3D# dr=
op ROLE legacy_owner;<br>ERROR: =C2=A0role &quot;legacy_owner&quot; cannot =
be dropped because some objects depend on it<br>DETAIL: =C2=A0privileges fo=
r schema public</div><div><br></div><div>I don&#39;t know where to look to =
find out what I need to alter to be able to remove the legacy role and inte=
rnet searches came up fruitless.<br></div><div><br></div><div>Does anyone h=
ave any hints or advice on where to look?</div><div><br></div><div>Thanks f=
or the help!</div><div><br></div><div>-m<br></div></div>

--000000000000414f69061bab965e--