-- Set context
use master
go

-- Delete login
if exists (select * from sys.server_principals where name = N'DBTest')
drop login DBTest
go

-- Create login
create login DBTest
with password = 'fop62822022', 
check_policy = off,
check_expiration = off, 
default_database = DBTest,
default_language = english;
go


-- Set context
use DBTest
go

-- Delete user
if exists (select name from sys.database_principals where name = N'DBTest')
drop user DBTest
go

-- Delete role
if  exists (select * from sys.database_principals where name = N'Application' and type = 'R')
drop role [Application]
go

-- Create user
create user DBTest;
go

-- Create role
create role [Application];
go 

-- Grant permissions to role
grant select, insert, update, delete, execute on schema::dbo to [Application];

-- Associate user to role
exec sp_addrolemember @membername = N'DBTest', @rolename = N'Application';
go