Security 1

these commands are done on sql Server with admin permissions

Create Login test226 with password= 'p@ssw0rd1', default_database=Adventureworks

Use AdventureWorks

Create user test226 for login Test226 with default_schema=HumanResources

--, default_schema='Humanresources'

Create Role HumanResourcesRoll

Grant Select on Schema::HumanResources to HumanResourcesRoll
Grant Update on Schema::HumanResources to HumanResourcesRoll

exec sp_addRolemember HumanResourcesRoll, test226