Hi All,
I need to GRANT Read only Permission on few Databases.How Can I acheive this in SQL Server 2005 ?
Thanks In Advance
Anoop
A:
A quick google search turns up plenty of answers.
such as this one...
But this question probably belongs on ServerFault.com
David Stratton
2010-08-11 01:44:19
+3
A:
Grant the user(s) the datareader role
exec *THE_DATABASE_NAME*..sp_addrolemember @rolename='db_datareader', membername='*THE_USERNAME*'
Dave Barker
2010-08-11 01:44:51
+1: Beat me to it
OMG Ponies
2010-08-11 01:45:37
hi dave thanks for the reply. I already tried using sp_addrolemember . Is there any other way we can GRANT Read Permissions without using sp_addrolemember ?
Anoop
2010-08-11 01:52:51
What happened when you used sp_addrolemember or don't you have permission?
Dave Barker
2010-08-11 01:54:43