Select from sys.server_permission for server wide permissions (grant deny roles etc) joined to sys.server_principles

Select from sys.database_permissions in each database for DB wide permissions joined to sys.database_principles