CREATE USER Will WITHOUT LOGIN; CREATE USER Vanessa WITHOUT LOGIN; GO ALTER ROLE GeneralUser ADD MEMBER Will; GO ALTER ROLE Salesperson ADD MEMBER Vanessa; GO EXECUTE AS USER = 'Will'; SELECT * FROM Sales.customers; REVERT; GO EXECUTE AS USER = 'Will'; SELECT * FROM Sales.customer_credit_cards; REVERT; GO EXECUTE AS USER = 'Will'; SELECT * FROM Sales.Staffs; REVERT; GO EXECUTE AS USER = 'Vanessa'; SELECT * FROM Sales.customers; REVERT; GO EXECUTE AS USER = 'Vanessa'; SELECT * FROM Sales.customer_credit_cards; REVERT; GO EXECUTE AS USER = 'Vanessa'; SELECT * FROM Sales.Staffs; REVERT; GO