Create user that can have access all tables in Schema1 but just have insert to specific table in Schema2

Question

Please consider this scenario: I have 2 Schemas: SCHEMA1, SCHEMA2

In each schema I have some tables.

I have two logins for each schemas.

I want to create a user that can access (CRUD operation) on all tables in SCHEMA1 but just can Insert in SCHEMA2.Table1.

How can I create this user?

Thanks

Answer 1

something like this?

USE master
GO

CREATE LOGIN MyLogin WITH PASSWORD = 'xyz';

USE mydb
GO

CREATE USER MyLogin for login MyLogin;

GRANT SELECT, INSERT, UPDATE, DELETE ON SCHEMA :: SCHEMA1 TO MyLogin;

GRANT INSERT ON [SCHEMA2].[Table1] TO MyLogin;