DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: dba_tab_privs references on custom roles

Threaded View

  1. #1
    Join Date
    Sep 2010
    Posts
    2

    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
    Last edited by da808wiz; 09-21-2010 at 08:39 PM.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width