Deturmining Role membership in T-SQL RRS feed

  • Question

  • Is there a way to deturmine if a user connected to SQL Server is a member of a particulat securty group?

    To be clear, I am not askign how to use a group to connect to SQL Server, I know how to do that. I am concerned with checking membership in an aditional (more specific) group once somone is connected.


    Friday, September 30, 2011 8:55 PM


  • Check is_member and IS_SRVROLEMEMBER function in BOL


    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
    Friday, September 30, 2011 8:59 PM