Finding empty Role(s)

From: Lyall Barbour <>
Date: Tue, 12 May 2020 16:13:36 +0200
Message-ID: <trinity-49563061-dbbb-489a-b950-7ba9bd74bb1e-1589292816711_at_3c-app-mailcom-lxa15>

Hello everyone,
  I'm either Googling the wrong keywords, or thinking about this too hard.  I just revoked a ton of object privs from a non-prod database in preparation for doing a decommission of a specific schema in a large database for the Business.  I'm now trying to find any Roles that are empty because of my revoking.  Does anyone have a script to do this?
Lyall Barbour
-- Received on Tue May 12 2020 - 16:13:36 CEST

Original text of this message