sun.master.usr

来自「一个管理系统系统,进销存等,功能比较完善,界面还可以」· USR 代码 · 共 12 行

/****** Object:  User dbo    Script Date: 2006-2-20 23:30:47 ******/
/****** Object:  User guest    Script Date: 2006-2-20 23:30:47 ******/
if not exists (select * from dbo.sysusers where name = N'guest' and uid < 16382 and hasdbaccess = 1)
	EXEC sp_grantdbaccess N'guest'
GO

/****** Object:  User suntao    Script Date: 2006-2-20 23:30:47 ******/
if not exists (select * from dbo.sysusers where name = N'suntao' and uid < 16382)
	EXEC sp_grantdbaccess N'suntao', N'suntao'
GO