Post reply

fixed server role

  • November 28, 2008 at 7:25 am

    #96732

    how to find the roles that were allotted to any user using query analyzer?thanks in advance

  • November 28, 2008 at 11:56 am

    #904922

    Hi,

    You are in 2000, right? Use sp_helpuser. If you use it 2005 it will not return information about securables introduced in 2005 but it will give all the group memberships.

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • November 30, 2008 at 8:25 am

    #905249

    Hi Elisabeth,

    Thanks so much.

    Iam newbie.

    Can you tell me for displaying permissions(both user defined and predefined ) any procedure like sp_helpuser in query analyzer?

    Regards,

    MAnjula

  • November 30, 2008 at 10:08 am

    #905264

    Hi,

    If I understand your requirement correctly, you can use sp_helprotect; it is documented in Books Online.

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • November 30, 2008 at 11:09 am

    #905276

    Hi Elisabeth,

    My requirement is "I want to display the users who have permissions of all roles inclusive server roles or database or userdefined roles."

    Thanks & Regards,

    MAnjula.

  • November 30, 2008 at 11:22 am

    #905278

    So you want to display users who are members of database and/or server roles? With the roles they are members of?

    You're not interested in permissions that users may have directly on objects?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 30, 2008 at 11:35 am

    #905281

    Hi,

    Yes.i need the roles and permissions(on which objects).

    Pls correct me if iam wrong.

    Thanks,

    MAnjula

  • November 30, 2008 at 11:48 am

    #905283

    Ok, so you need the users, with their database and server roles and with the permissions that they have directly on database objects.

    One database or all?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 30, 2008 at 12:06 pm

    #905290

    Hi,

    All databases

    Thanks

    MAnjula

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply