mcad_zsauthset.sql

微软msde

use [mcad_zs]

go
exec sp_revokedbaccess 'ison_zs_sa'
go

use [master]

declare @a varchar(20)

select @a=name from [master].[dbo].[sysxlogins] where name='ison_zs_sa'

if @a is not null

   BEGIN

   EXEC sp_droplogin 'ison_zs_sa'

   END

go

exec sp_addlogin 'ison_zs_sa','62757890','master','simplified chinese'

go

use [mcad_zs]

go
exec sp_grantdbaccess N'ison_zs_sa',N'ison_zs_sa'

exec sp_addrolemember N'db_owner',N'ison_zs_sa'

go
grant select,insert,update,delete on [dbo].[customer] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[mzdj] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Yk_ykxx] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[yk_ypgys] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Yk_ypxx] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Yk_yplbxx] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Yk_ypcrkxx] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[zyjbxx] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Yh_qxdyxx] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Yh_qxxx] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Yh_qxdyxx] to [ison_zs_sa]
grant select,insert on [dbo].[Rzxx] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Jz_brjzxx] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Mzbl] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Mzyz_who] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[mzyzcf] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Jz_sjxx] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Jz_bjxx] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Jz_yfkxx] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Xllbxx] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Xllbnr] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[For_updates] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Op_path] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[tempnumberkey] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Theinfo] to [ison_zs_sa]
grant select,insert,update on [dbo].[Id_get] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Temp_info] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Temptest] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Zyclients] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[Dct_online] to [ison_zs_sa]
grant select,insert,update,delete on [dbo].[tempindexkey] to [ison_zs_sa]
go