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

IF SUSER_ID('gaps') IS NULL
				BEGIN CREATE LOGIN gaps WITH PASSWORD = 0x02007868AC6E83FCA949CA70084EB581D31B0A3250B24BCD718FBF84ECC05497F363E5E71998D54DA43654FB138F1FBF70CDE6A4EB606E19DB0A17DC41AA0136E2F77DD01598 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