开发者

SQL Server Read Only Permissions

I need to GRANT Read only Pe开发者_如何学JAVArmission on few Databases. How Can I achieve this in SQL Server 2005 ?


Grant the user(s) the datareader role

exec *THE_DATABASE_NAME*..sp_addrolemember @rolename='db_datareader', membername='*THE_USERNAME*'


A quick google search turns up plenty of answers.

such as this one...

But this question probably belongs on ServerFault.com

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜