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

Home -> Community -> Usenet -> c.d.o.server -> Re: Role not found in ROLE_SYS_PRIVS and ROLE_TAB_PRIVS

Re: Role not found in ROLE_SYS_PRIVS and ROLE_TAB_PRIVS

From: EdStevens <quetico_man_at_yahoo.com>
Date: 11 Oct 2006 11:33:09 -0700
Message-ID: <1160591589.587226.165170@k70g2000cwa.googlegroups.com>

chip_ling_at_yahoo.ca wrote:
> Dear all,
>
> I am trying to support an existing 9i database but I have something I
> do not understand.
>
> I found a role that used by most of the users from the dba_role,
> dba_role_privs and user$ tables.
>
> However, I failed to find out what system privileges and table
> privileges granted to the role. I tried to check the role_sys_privs and
> role_tab_privs, but I could not find the role entry.
>
> I did a small test on the test environment by creating a new role,
> create a new user and then grant the role to the user. In that way, I
> can find all the relationship via the role_sys_privs and
> role_tab_privs.
>
> Here is what I did:
>
> CREATE ROLE GENERAL_USER_ROLE;
> GRANT CREATE SESSION TO GENERAL_USER_ROLE;
> GRANT SELECT ON APP1.TABLE1 TO GENERAL_USER_ROLE;
> GRANT SELECT ON APP1.VIEW1 TO GENERAL_USER_ROLE;
> GRANT EXECUTE ON TVIEW.PROC1 TO GENERAL_USER_ROLE;
>
> CREATE USER SAM IDENTIFIED BY SAM DEFAULT TABLESPACE DATA TEMPORARY
> TABLESPACE TEMP;
>
> GRANT GENERAL_USER_ROLE TO SAM;
>
> So I think the DBA before me must be using other way to create the role
> and/or grant the table privileges to the role. Any suggestion?
>
> Rgds,
> Chip

There are no "other" ways to create and assign roles. Perhaps if you showed us the queries you used to produce the results that you find puzzeling. Received on Wed Oct 11 2006 - 13:33:09 CDT

Original text of this message

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