test in tsql to determine if user belongs to a role

Last Post 15 Oct 2008 05:04 AM by SwePeso. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
timcronin
New Member
New Member

--
14 Oct 2008 01:58 PM
Is there a way in tsql you can test if a windows\sql account belongs to a role created inside of a database when that account is connected. So if domain\testuser has a login and belongs to a role on the sales database call accoutadmin.
SwePeso
New Member
New Member

--
15 Oct 2008 05:04 AM
SELECT IS_MEMBER('myrole')
You are not authorized to post a reply.

Acceptable Use Policy