--让 SQL Server 登陆帐户“sp_read”访问多个数据库
use mydb
go
create user sp_read for login sp_read with default_schema=dbo
go
exec sp_addrolemember 'db_datareader', 'sp_read'
go
use mydb2
go
create user sp_read for login sp_read with default_schema=dbo
go
exec sp_addrolemember 'db_datareader', 'sp_read'
go