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

Thread: Retrieval of Role granted by 1 user to an other user

  1. #1
    Join Date
    Nov 2004
    Posts
    6

    Retrieval of Role granted by 1 user to an other user

    Hi...

    I would like to retrieve roles granted by a user to some other user. Any idea which data dictionary tables will give me the grantee and the reciever of the roles that this particular user has granted.

    No other roles/ users should be picked up.

    The SQL has to run for the logged on DBA user

    If User A
    grants Role R1 to User B
    I would like to retrieve the role that B has got from A. ie : R1 Logged on User A


    Thanks in Advance

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    No, you can't get who granted a particular role to a particulaar user. It is not recorded in a database dictionary. If you need to track that information then you'll have to turn on auditing on SYSTEM GRANT and get the information you need from audit trail.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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