text: ﻿
  CREATE ROLE [DataViewer] AUTHORIZATION [dbo]
  GO
  
  -- Grant access rights to a specific schema in the database
  GRANT 
  	REFERENCES, 
  	SELECT, 
  	VIEW DEFINITION 
  ON SCHEMA::[Payments2]
  	TO [DataViewer]
  GO
  
  GRANT 
  	REFERENCES, 
  	SELECT, 
  	VIEW DEFINITION 
  ON SCHEMA::[Metrics]
  	TO [DataViewer]
  GO