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
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')


Acceptable Use Policy
---