gaps.sql 471 B

123456
  1. IF SUSER_ID('gaps') IS NULL
  2. BEGIN CREATE LOGIN gaps WITH PASSWORD = 0x020091D5BBBB76452E2C627EC162013D8F0127CC92DD0458B27A79C2628F91B55065DE9DF6F09F7FBA734623119E0F3F1E0CE4E84EB52561D362816C5B9823B1DE051780203F HASHED END
  3. CREATE USER [gaps] FOR LOGIN [gaps] WITH DEFAULT_SCHEMA = [dbo]
  4. /*ALTER ROLE db_ddladmin ADD MEMBER gaps*/ exec sp_addrolemember 'db_ddladmin', 'gaps'
  5. /*ALTER ROLE db_datareader ADD MEMBER gaps*/ exec sp_addrolemember 'db_datareader', 'gaps'
  6. GO