1

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'; – Braiynnes Nov 16 '17 at 11:11
  • Please consider posting your solution as an answer. That will make it more visible as well as let you format it better. Thank you. – Andriy M Nov 17 '17 at 8:11
0

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'; 

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.