ROLE_TAB_PRIVS

[gaegoori]

If I want to see all the privileges on a certain role don't I need to use ROLE_TAB_PRIVS?.... But weird thing is that when I use sql*plus to select * from role_tab_privs where role='TEST_USER', I get no rows selected. If I go to Oracle Enterprise Manager and see the role, I see a role called TEST_USER. How come I don't see this role in sql*plus?

I also select * from dba_roles and see a role called TEST_USER.

This is on Oracle 8.1.7 on Solaris 8

[aarroyob]

Your query only said you that there are not table privilegies granted to that role. What do you want to know?

You can select * from dict where table_name like '%ROLE%';
It will give you the table name and its description.

Cheers

Angel

[bensmail]

Try
dba_sys_privs

[gaegoori]

let me ask differently. I see TEST_USER role on Enterprise Manager but not through role_tab_privs or role_sys_privs, but I see a TEST_USER role on dba_roles. How come I cannot see TEST_USER role thru %ROLE% dictionary?