I have been trying to figure out how to do this for a few days. I thought this would be simple but I keep getting an error. I am trying to list all of the roles AND users that have access to a table in Oracle 11g. I am new to this but I tried this:
SELECT * FROM all_users, dba_role_privs
WHERE table = 'data_mart'
What am I doing wrong? Thanks for your help.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.