How to show all system privileges for all users in Oracle database
&quot;Retrieving all user privileges within Oracle can range from a simple task using a basic SQL query to an advanced script, depending primarily on how involved the roles and privileges are configured within the server.&quot;
https://chartio.com/resources/tutorials/oracle-user-privileges--how-to-show-all-privileges-for-a-user/