dba_tab_privs references on custom roles
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
Thanks for everyone's input
http://www.google.com/url?url=http:/...R0Ec1AKekdLPyg
Looks like it is not possible to assign INDEX or REFERENCES to a role.
The weird part about it is when I issue the same commands that BeefStu does, I get "grant succeeded."
When I searched for it in the various role tables, I couldn't find it. If it's not possible, it would be better if I received an error message. I'm running 32-bit 10.2 if that makes any difference.
Gz