pls provide the query for get the List of users having access to sqlserver and their roles.

Question

Viewing 4 posts - 1 through 3 (of 3 total)

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

ksjayadev SSC Journeyman Points: 96 More actions · Answer 1

This might help

crazy4sql SSCoach Points: 19590 More actions · Answer 2

http://www.sqlservercentral.com/articles/Administration/listofdatabaseuserswithdatabaseroles/1545/

In addition to above, to check the permission for a perticular user, you can use sp_helprotect.

For Ex. :-

exec sp_helprotect @username='test'

----------
Ashish

charipg SSCrazy Eights Points: 9888 More actions · Answer 3

SSCrazy Eights

Points: 9888

February 14, 2011 at 8:48 pm

Thanks a lot....