I'm trying to use your post to grant a group-user read access to all databases, but I get the error message below.
Please assist
Msg 15259, Level 16, State 1, Line 1
The DEFAULT_SCHEMA clause cannot be used with a Windows group or with principals mapped to certificates or asymmetric keys.