/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 vote345 views1 answer
Postgres cast as currency format
SQL
0 vote355 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote384 views1 answer
Postgres - Login and connect as default user
SQL
0 vote324 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL
1 vote324 views1 answer
Sql server get users
SQL
0 vote317 views4 answers
Sql year
SQL
16 votes322 views6 answers
Insert sql
SQL
0 vote330 views1 answer
Sql trying to delete database in use
SQL
0 vote316 views2 answers
Show slave status mysql
SQL
1 vote334 views1 answer
Where to locate set password for mysql
SQL