Grant user permission to login to the database:
CREATE USER ROA_NAME FOR LOGIN ROA_NAME
Add user to the group:
EXEC SP_ADDROLEMEMBER 'DB_DATAREADER', 'ROA_NAME'
“Members of the db_datareader fixed database role can run a SELECT statement against any table or view in the database.”
// Proudly powered by Apache, PHP, MySQL, WordPress, Bootstrap, etc,.