/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

2 votes287 views5 answers
Install postgresql 10 centos 7
SQL
0 vote284 views1 answer
Where date major today mysql
SQL
0 vote297 views3 answers
How to verify sequence result in oracle SQL
SQL
1 vote273 views1 answer
Drop df constraint sql server
SQL
1 vote258 views1 answer
Not exists mysql
SQL
0 vote265 views1 answer
SQL isnumeric DB2
SQL
0 vote302 views1 answer
Hue hive UploadingTextFiletoHive
SQL
1 vote266 views3 answers
Mysql disable foreign keys check
SQL
0 vote312 views1 answer
FIND most frequent word in sql server
SQL
0 vote269 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL