日期:2014-05-17 浏览次数:20482 次
USE [master]也可以给只读权限:
GO
CREATE LOGIN [testlogin] WITH PASSWORD=N'123', DEFAULT_DATABASE=[AdventureWorks2008R2], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE [AdventureWorks2008R2]
GO
CREATE USER [testlogin] FOR LOGIN [testlogin]
GO
USE [AdventureWorks2008R2]默认帐号对tempdb和master都有读写权限
GO
ALTER ROLE [db_datareader] ADD MEMBER [testlogin]
GO