/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

1 vote291 views1 answer
Mysql how to reset primary key
SQL
0 vote276 views1 answer
What is between operator
SQL
0 vote279 views1 answer
Low level operator in dbms
SQL
0 vote308 views1 answer
SQL Server date literal
SQL
-1 vote286 views1 answer
How to create foreign key in sql server management studio
SQL
1 vote277 views1 answer
Mysql history command
SQL
2 votes293 views1 answer
Oracle percentage
SQL
0 vote293 views1 answer
If column value is null then in mysql
SQL
2 votes334 views2 answers
Null column to 0 in mysql
SQL
0 vote313 views1 answer
SQL: calculate hours from two dates
SQL