Data Dictionary table name required ..
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Data Dictionary table name required ..

  1. #1
    Join Date
    Nov 2004
    Posts
    6

    Data Dictionary table name required ..

    Hi ..

    I would like to get the name of the Data dictionary table which holds the grants like connect / resource to a particular user.
    Just after a user is created, these grants are applied for the new user to work on oracle.
    Any idea which data dict table I would have to query.

    Thanks in adv for any reply ..

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,026
    Like this?

    Code:
    SQL> SELECT * FROM dict WHERE table_name LIKE '%SYS%PRIV%';
    
    TABLE_NAME                     COMMENTS
    ------------------------------ ------------------------------------------------------------
    USER_RSRC_MANAGER_SYSTEM_PRIVS system privileges for the resource manager for the user
    USER_SYS_PRIVS                 System privileges granted to current user
    ROLE_SYS_PRIVS                 System privileges granted to roles
    
    Elapsed: 00:00:00.94
    SQL> 
    
    LIDXPNN - t31a=> SELECT * FROM dict WHERE table_name LIKE '%ROLE%';
    
    TABLE_NAME                     COMMENTS
    ------------------------------ --------------------------------------------
    USER_ROLE_PRIVS                Roles granted to current user
    ROLE_ROLE_PRIVS                Roles which are granted to roles
    ROLE_SYS_PRIVS                 System privileges granted to roles
    ROLE_TAB_PRIVS                 Table privileges granted to roles
    SESSION_ROLES                  Roles which the user currently has enabled.
    10 rows selected.
    
    Elapsed: 00:00:00.71
    this space intentionally left blank

  3. #3
    Join Date
    Nov 2004
    Posts
    6
    Thanks ..
    That was fast ...

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