Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> ROLES & such

ROLES & such

From: Charlie Mengler <charliem_at_mwh.com>
Date: Thu, 27 Apr 2000 10:26:03 -0700
Message-Id: <10480.104334@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US