Granting a SQL Server database only user execute on xp_instance_regread fails
So if anyone is curious the fast answer was to go into the UI and add the foo user to master thru the user mapping tab.

Wonder why?