User Access Management Process exercise

[aliceinhell]

I know that users can be given permission to access the database to select data from database as shown below. But doing this for each user in the user table would take ages.. is there any method i could do this for all users in the user table

I want to give all of them roles to allow them to read certain tables only.. any ideas how this can be done.. but i dont want to do one user at a time i want to do the whole user table

CREATE LOGIN sam
WITH PASSWORD = '';
USE AdventureWorks;
CREATE USER sam FOR LOGIN sam;
GO
GRANT SELECT TO sam

[Rabbit]

What have you tried so far?