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

Thread: ROLE_TAB_PRIVS

  1. #1
    Join Date
    Jun 2001
    Posts
    243
    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

  2. #2
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    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

  3. #3
    Join Date
    Mar 2002
    Posts
    301
    Try
    dba_sys_privs

  4. #4
    Join Date
    Jun 2001
    Posts
    243
    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?

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