SP_Who - Need What Role Person Has?

[smedvid]

Are there any other internal SPs that may list the role(s) that a user has. I need to develop an security model around the Role Names via VBA Code ... tia,



Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[hmckillop]

sp_helpuser I think does this
or sp_helpsrvrolemember lets you view the members of a fixed server role.


"I'm living so far beyond my income that we may almost be said to be living apart

 

[smedvid]

Thanks

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...