How to list all users with select any table permission in oracle?

@wilmer.lemke 

To list all users with the SELECT ANY TABLE permission in Oracle, you can run the following query:

1
2
3
4

SELECT grantee
FROM dba_tab_privs
WHERE privilege = 'SELECT'
AND table_name = 'ANY';

This query retrieves the list of users who have been granted the SELECT ANY TABLE privilege in the database. The DBA_TAB_PRIVS view contains information about table privileges granted to users and roles in the database.