Finding empty Role(s)
From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Tue, 12 May 2020 16:13:36 +0200
Message-ID: <trinity-49563061-dbbb-489a-b950-7ba9bd74bb1e-1589292816711_at_3c-app-mailcom-lxa15>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 12 2020 - 16:13:36 CEST
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?
TIA
Lyall Barbour