快速新建SQL相同权限账号

1. 先得到旧帐号bbsc的权限：

sp_helprotect null,'bbsc'

Owner	Object	Grantee	Grantor	ProtectType	Action	Column
dbo	WSCParameter	bbsc	dbo	Grant	Select	(All+New)
dbo	WSCParameterType	bbsc	dbo	Grant	Select	(All+New)
dbo	WSCTeam	bbsc	dbo	Grant	Select	(All+New)
dbo	WSCUserTeamMap	bbsc	dbo	Grant	Select	(All+New)
PMS	v_PMSITEMViewForHI4	bbsc	PMS	Grant	Select	(All)

2. 生成Grant脚本，将权限赋予新帐号anny：

Grant    

Select	ON	dbo	.	WSCParameter	TO	anny
Grant	Select	ON	dbo	.	WSCParameterType	TO	anny
Grant	Select	ON	dbo	.	WSCTeam	TO	anny
Grant	Select	ON	dbo	.	WSCUserTeamMap	TO	anny
Grant	Select	ON	PMS	.	v_PMSITEMViewForHI4	TO	anny

将dbo和.后面的空格去掉执行即可，SELECT不是一定的，对照上表Action的值！