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