In Oracle, how to get a list with the names of schemas that a user has read permission?
you can use the following command if you want to see the users that has X privilege for example SELECT ANY TABLE privileges

SELECT * FROM USER_ROLE_PRIVS WHERE GRANTED_ROLE like '%SELECT ANY TABLE%';