Let's say we've logged on under the A schema.

I am able to execute the following statement

grant select on wph_pden to LANDING_R;

However, the LANDING_R object can not be located in the schema A. It is absent from all the system tables and views.

How do I find out which schema owns the LANDING_R (which I know is a role, not user)???

  • 1
    I'm sorry I don't understand what you're saying. Roles don't belong to schemas. Are you asking how to find what users were granted that role? – Mat Apr 25 '14 at 7:54
  • Is there a way to find out which user created a particular role? – Dennis Apr 25 '14 at 8:14

Roles are not owned, but granted to users:

select grantee from dba_role_privs where granted_role = 'LANDING_R';

Object privileges granted to LANDING_R:

select * from dba_tab_privs where grantee = 'LANDING_R';

System privileges granted to the LANDING_R:

select * from dba_sys_privs where grantee = 'LANDING_R';

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.