/SQL/The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.

The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.

select dp.name as db_role, dp2.name as db_user
from sys.database_role_members drm
join sys.database_principals dp on (drm.role_principal_id = dp.principal_id)
join sys.database_principals dp2 on (drm.member_principal_id = dp2.principal_id)
order by dp.name

Source: stackoverflow.com

Similar codes

0 vote294 views1 answer
How to set up an anonymous function to variable in swift
SQL
6 votes284 views4 answers
Mysql group by month
SQL
0 vote292 views1 answer
One table with another
SQL
27 votes278 views6 answers
Sql update record
SQL
23 votes297 views4 answers
How to show all users in mysql
SQL
10 votes297 views2 answers
Doublon sql
SQL
0 vote257 views1 answer
Mysql select all where count more than"
SQL
1 vote259 views1 answer
How to select random rows from table
SQL
15 votes263 views4 answers
T-sql drop function if exists
SQL
0 vote264 views1 answer
Increase speed of like queries postgres
SQL