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

Thread: List of Privileges given to exp_full_database role

  1. #1
    Join Date
    Oct 2001
    Location
    Hyderabad, India
    Posts
    15
    Where can i get a list of privileges given to exp_full_database, imp_full_database and dba role?

    Is there any table/view which will show all the privileges granted to a role ?

    - Milind

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    For system privileges granted to EXP_FULL_DATABASE role:

    select * from dba_sys_privs
    where grantee='EXP_FULL_DATABASE';

    For other roles granted to EXP_FULL_DATABASE role:

    select * from dba_role_privs
    where grantee='EXP_FULL_DATABASE';


    [Edited by jmodic on 07-19-2002 at 08:53 AM]
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3

    Is this what you need?

    SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='EXP_FULL_DATABASE';

    GRANTEE GRANTED_ROLE ADM DEF
    ------------------------------ ------------------------------ --- ---
    EXP_FULL_DATABASE EXECUTE_CATALOG_ROLE NO YES
    EXP_FULL_DATABASE SELECT_CATALOG_ROLE NO YES
    www.cnoug.org

  4. #4
    Join Date
    Oct 2001
    Location
    Hyderabad, India
    Posts
    15
    jmodic gave me correct answer.

    Regarding chao_ping's answer

    Ive gone thru roles granted to exp_full_database.
    i found at the end both are having same role ie HS_ADMIN_ROLE and it has no privileges.
    what does it mean?

    check out this o/p


    SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='EXP_FULL_DATABASE';

    GRANTEE GRANTED_ROLE ADM DEF
    ------------------------------ ------------------------------ --- ---
    EXP_FULL_DATABASE EXECUTE_CATALOG_ROLE NO YES
    EXP_FULL_DATABASE SELECT_CATALOG_ROLE NO YES

    SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='EXECUTE_CATALOG_ROLE';

    GRANTEE GRANTED_ROLE ADM DEF
    ------------------------------ ------------------------------ --- ---
    EXECUTE_CATALOG_ROLE HS_ADMIN_ROLE NO YES

    SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='HS_ADMIN_ROLE';

    no rows selected

    SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='SELECT_CATALOG_ROLE';

    GRANTEE GRANTED_ROLE ADM DEF
    ------------------------------ ------------------------------ --- ---
    SELECT_CATALOG_ROLE HS_ADMIN_ROLE NO YES

    SQL> SELECT * FROM DBA_ROLE_PRIVS where grantee='HS_ADMIN_ROLE';

    no rows selected

    SQL> select * from dba_sys_privs where grantee='HS_ADMIN_ROLE';

    no rows selected


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