--创建数据库用户修改权限和密码
/*
先创建四个用户:
DragonNest
SPExecutor
GSMAdmin
program_server
*/
--创建数据库用户
----------------------------------------------------------------------------
use master
go
--创建用户1
if not exists (select * from master.dbo.syslogins where name = 'DragonNest')
begin
exec sp_addlogin 'DragonNest', 'E6h7HsRXJbH8ays'
end
if not exists (select * from sysusers where name = 'DragonNest')
begin
exec sp_adduser 'DragonNest', 'DragonNest'
end
--创建用户2
if not exists (select * from master.dbo.syslogins where name = 'SPExecutor')
begin
exec sp_addlogin 'SPExecutor', 'E6h7HsRXJbH8ays'
end
if not exists (select * from sysusers where name = 'SPExecutor')
begin
exec sp_adduser 'SPExecutor', 'SPExecutor'
end
--创建用户3
if not exists (select * from master.dbo.syslogins where name = 'GSMAdmin')
begin
exec sp_addlogin 'GSMAdmin', 'E6h7HsRXJbH8ays'
end
if not exists (select * from sysusers where name = 'GSMAdmin')
begin
exec sp_adduser 'GSMAdmin', 'GSMAdmin'
end
--创建用户4
if not exists (select * from master.dbo.syslogins where name = 'program_server')
begin
exec sp_addlogin 'program_server', 'E6h7HsRXJbH8ays'
end
if not exists (select * from sysusers where name = 'program_server')
begin
exec sp_adduser 'program_server', 'program_server'
end
----------------------------------------------------------------------------
--1
--------------------------------------------------------------------------------
use DNMembership;
go
EXEC sp_change_users_login 'UPDATE_ONE','DragonNest', 'DragonNest';
EXEC sp_change_users_login 'UPDATE_ONE','SPExecutor','SPExecutor';
EXEC sp_change_users_login 'UPDATE_ONE','GSMAdmin','GSMAdmin';
EXEC sp_change_users_login 'UPDATE_ONE','program_server','program_server';
--use DNMembership;
--exec sp_change_users_login 'REPORT';
--go
--------------------------------------------------------------------------------
--2
--------------------------------------------------------------------------------
use DNWorld;
go
EXEC sp_change_users_login 'UPDATE_ONE','DragonNest', 'DragonNest';
EXEC sp_change_users_login 'UPDATE_ONE','SPExecutor','SPExecutor';
EXEC sp_change_users_login 'UPDATE_ONE','GSMAdmin','GSMAdmin';
EXEC sp_change_users_login 'UPDATE_ONE','program_server','program_server';
--exec sp_change_users_login 'REPORT';
--go
--------------------------------------------------------------------------------
--3
--------------------------------------------------------------------------------
use DNGSM;
go
--EXEC sp_change_users_login 'UPDATE_ONE','DragonNest', 'DragonNest';
EXEC sp_change_users_login 'UPDATE_ONE','SPExecutor','SPExecutor';
EXEC sp_change_users_login 'UPDATE_ONE','GSMAdmin','GSMAdmin';
EXEC sp_change_users_login 'UPDATE_ONE','program_server','program_server';
--exec sp_change_users_login 'REPORT';
--go
--------------------------------------------------------------------------------
--4
--------------------------------------------------------------------------------
use DNServerLog;
go
EXEC sp_change_users_login 'UPDATE_ONE','DragonNest', 'DragonNest';
EXEC sp_change_users_login 'UPDATE_ONE','SPExecutor','SPExecutor';
EXEC sp_change_users_login 'UPDATE_ONE','GSMAdmin','GSMAdmin';
EXEC sp_change_users_login 'UPDATE_ONE','program_server','program_server';
--exec sp_change_users_login 'REPORT';
--go
--------------------------------------------------------------------------------
--5
--------------------------------------------------------------------------------
use DNStaging;
go
EXEC sp_change_users_login 'UPDATE_ONE','DragonNest', 'DragonNest';
EXEC sp_change_users_login 'UPDATE_ONE','SPExecutor','SPExecutor';
EXEC sp_change_users_login 'UPDATE_ONE','GSMAdmin','GSMAdmin';
EXEC sp_change_users_login 'UPDATE_ONE','program_server','program_server';
--exec sp_change_users_login 'REPORT';
--go
--------------------------------------------------------------------------------
--6
--------------------------------------------------------------------------------
use DNWorld;
go
EXEC sp_change_users_login 'UPDATE_ONE','DragonNest', 'DragonNest';
EXEC sp_change_users_login 'UPDATE_ONE','SPExecutor','SPExecutor';
EXEC sp_change_users_login 'UPDATE_ONE','GSMAdmin','GSMAdmin';
EXEC sp_change_users_login 'UPDATE_ONE','program_server','program_server';
go
--exec sp_change_users_login 'REPORT';
--go
--------------------------------------------------------------------------------
-------------------------------------------------
sp_password NULL,'E6h7HsRXJbH8ays','DragonNest';
go
sp_password NULL,'E6h7HsRXJbH8ays','SPExecutor';
go
sp_password NULL,'E6h7HsRXJbH8ays','GSMAdmin';
go
sp_password NULL,'E6h7HsRXJbH8ays','program_server';
go
-------------------------------------------------