Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> ROLES & such
I'm trying to identify who has which privs in one of my instances.
I have a handleful of users (schemas) that show they have been granted "HR_ALL" role.
At this point in time, I'm not sure that this role really exists. (See below.)
Where else should I be looking to see which, if any, privs are associated
with the HR_ALL role?
SQL> set echo on
SQL> select grantee, granted_role
2 from dba_role_privs
3 where grantee = 'ALTAC'
4 /
GRANTEE GRANTED_ROLE ------------------------------ ------------------------------ ALTAC CONNECT ALTAC HR_ALL
SQL> select role from role_role_privs
2 where role = 'HR_ALL'
3 /
no rows selected
SQL> select role from role_sys_privs
2 where role = 'HR_ALL'
3 /
no rows selected
SQL> select role from role_tab_privs
2 where role = 'HR_ALL'
3 /
no rows selected
-- Charlie Mengler Maintenance Warehouse charliem_at_mwh.com 5505 Morehouse Drive 858-552-6229 San Diego, CA 92121 If you don't use vi, then you shouldn't be working on UNIX!Received on Thu Apr 27 2000 - 12:26:03 CDT
![]() |
![]() |