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