Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    18

    Unanswered: Retrieving user defined Role name

    Is there a System stored procedure that gives me the Role in which a user is in. For example I execute this procedure, give the user as parameter an that gives me back the Role the user is in. It has to be said that this is a user defined role, I got three of them, HR, Employee, Approver.

    Greetings,
    Godofredo

  2. #2
    Join Date
    Mar 2004
    Posts
    18
    Is it not clear? I just want to retrieve a user defined Role

    Greets,
    geoff

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd use sp_helpuser.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •