Home Forums SQL Server 2005 SQL Server 2005 Security Check if Windows User is an SQL Admin RE: Check if Windows User is an SQL Admin

  • February 18, 2009 at 8:40 am

    #946008

    IS_MEMBER function checks whether the current user is a member of the specified windows or sql database role. And to check specifically for object level permissions, see PERMISSIONS function.

    --Ramesh