Hi,
I'm wondering why the REFERENCES privilege for a user defined role does not appear in the DBA_TAB_PRIVS table?
example:
create role mycustomrole identified by mycustomrole;
grant references on theowner.thetable to mycustomrole;
grant alter on theowner.thetable to mycustomrole;
grant mycustomrole to myuser1;
grant references on theowner.thetable to myuser2;
select owner,table_name,privilege,grantee from dba_tab_privs where owner='THEOWNER';
Code:
OWNER TABLE_NAME PRIVILEGE GRANTEE
---------- ---------- ---------- ------------
THEOWNER THETABLE REFERENCES MYUSER2
THEOWNER THETABLE ALTER MYCUSTOMROLE
Note mycustomrole does not show up.
Am I looking in the wrong place?
FYI, I am running Oracle 10g, if that matters.
Thanks