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

Thread: User's Roles and Privileges

  1. #1
    Join Date
    Apr 2002
    Posts
    86

    User's Roles and Privileges

    Can someone help with a query which can provide all users and their access information like USER, ROLE, GRANTEE information.

    Thanks In Advance

  2. #2
    Join Date
    Aug 2001
    Posts
    267
    select * from DBA_ROLE_PRIVS ,, If not enough

    Have to join with DBA_ROLES and DBA_USERS
    Raghu

  3. #3
    Join Date
    Apr 2002
    Posts
    86
    Some more info :
    I need USER, GRANTEE, ROLE, PRIVILIGES for all the users.

  4. #4
    Join Date
    Oct 2002
    Posts
    807

  5. #5
    Join Date
    Apr 2002
    Posts
    86
    Thanks. But this is not really helping. I couldn't find anything which provides USERS and their ROLES.

  6. #6
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    Originally posted by harrygulls
    Thanks. But this is not really helping. I couldn't find anything which provides USERS and their ROLES.
    SELECT GRANTED_ROLE, GRANTEE FROM DBA_ROLE_PRIVS

  7. #7
    Join Date
    Oct 2002
    Posts
    807
    Originally posted by harrygulls
    Thanks. But this is not really helping. I couldn't find anything which provides USERS and their ROLES.
    It's all there. You need to help yourself and modify them appropriately.

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