- How to get list of user roles in SQL Server?
- How do you view the roles and permissions granted to any database user in Azure SQL server instance?
How to get list of user roles in SQL Server?
To find all the role assignments to users in SQL Server database, you can use the following query. SELECT r.name role_principal_name, m.name AS member_principal_name FROM sys. database_role_members rm JOIN sys. database_principals r ON rm.
How do you view the roles and permissions granted to any database user in Azure SQL server instance?
Expand the Azure SQL DB and navigate to security -> Roles -> Database Roles to get a list of available fixed database roles, expand the Azure SQL DB and navigate to Security -> Roles -> Database Roles. You get the following fixed-database roles. The following table lists the database roles and their description.