CREATE NEW USER AND GRANT PERMISSION for INSER/UPDATE/DELETE IN SQL SERVER

 Use YourDatabase;

GO

--- Create User

IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = N'NewUserName')

BEGIN

    CREATE USER [NewAdminName] FOR LOGIN [NewAdminName]

    EXEC sp_addrolemember N'db_owner', N'NewUserName'

END;

GO

--database level permission

GRANT SELECT,UPDATE,INSERT,DELETE ON dbo.SampleDatabase TO user;

-- Schema level permission

GRANT SELECT,UPDATE,INSERT,DELETE ON SCHEMA::dbo TO user;