Four common conflict minerals, clockwise from top left: coltan, cassiterite, gold ore, and wolframite. Conflict resources are natural resources extracted in a conflict zone and sold to perpetuate the fighting. There is both anecdotal and statistical evidence that belligerent accessibility to precious commodities can prolong conflicts (a resource curse).
The public server role is not a fixed server role, because the permissions can be changed. The public server role is granted VIEW ANY DATABASE permission and the CONNECT permission on the default endpoints (TSQL Local Machine, TSQL Named Pipes, TSQL Default TCP, TSQL Default VIA). Members of the securityadmin fixed server role can grant both server-level and database-level permissions.
The loginmanager role has permission to create logins, and the dbmanager role has permission to create databases. You can view which users belong to these roles by using the query you have above against the master database. You can also determine the role memberships of users on each of your user databases by using the same query (minus the filter predicate) while connected to them. share | improve this answer.