main
1use [gorilla]
2GO
3if not exists (select * from dbo.sysusers where name = N'arc\mkhan' and uid < 16382)
4 EXEC sp_grantdbaccess N'arc\mkhan', N'arc\mkhan'
5GO
6
7if not exists (select * from dbo.sysusers where name = N'WebUser' and uid > 16399)
8 EXEC sp_addrole N'WebUser'
9GO
10
11exec sp_addrolemember N'WebUser', N'arc\mkhan'
12GO