Re: Role not found in ROLE_SYS_PRIVS and ROLE_TAB_PRIVS

> 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.

Have you checked DBA_SYS_PRIVS and DBA_TAB_PRIVS?

SELECT privilege FROM dba_sys_privs
WHERE grantee='ROLE_NAME';
SELECT owner,table_name,privilege FROM dba_tab_privs WHERE grantee='ROLE_NAME';

> 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?

There is only one way to create a role...with the CREATE ROLE statement. And there is only one way to grant privileges...with the GRANT statement.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown