C11/System/LOCOSOFT/SQL/schema/GC/users/gaps.sql

IF SUSER_ID('gaps') IS NULL
				BEGIN CREATE LOGIN gaps WITH PASSWORD = 0x0200B8A773F47B9FF85F6052343339696158705C4600A6DC6E61435C42D3B8FA4BA6566526871FB53A14DF5BC697CC57D2DC95467A300FEF1C8569CFF1CF863FB7243C098359 HASHED END
CREATE USER [gaps] FOR LOGIN [gaps] WITH DEFAULT_SCHEMA = [dbo]
/*ALTER ROLE db_ddladmin ADD MEMBER gaps*/ exec sp_addrolemember 'db_ddladmin', 'gaps'
/*ALTER ROLE db_datareader ADD MEMBER gaps*/ exec sp_addrolemember 'db_datareader', 'gaps'
GO