How do I find all roles that grant access to objects under a particular schema? I need to assign a user to any roles that grant access to tables under a particular schema. What would I query to find those roles?
I believe I got it - replying to my own question in case anyone needs the info: 

select * from role_tab_privs where owner = 'SCHEMA_NAME';