Tagged: SQL Server Roles and User List

Listing Users and Their Roles in SQL Server

Hello everyone, In this article, I will provide information about listing users and their roles in SQL Server. In SQL Server, in some cases, we may want to list users and their roles. You can easily do this with the help of the code below. SELECT spU.name, MAX( CASE WHEN...

Don`t copy text!