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
精彩评论