August 14, 2009 at 12:16 pm
how to give read access on a particular database to all users on a server
August 15, 2009 at 4:49 am
This will help you.
GRANT SELECT ON DATABASE:: TO public
Alternatively, you can also add those users in DATAREADER Role also.
Regards,
Sarabpreet Singh 😎
Sarabpreet.com
SQLChamp.com
Twitter: @Sarab_SQLGeek
August 17, 2009 at 4:54 am
Granting read permission to Public role will be easiest way. 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 18, 2009 at 7:24 am
It's not a good idea to grant any additional rights to the Public. The preferred method is to:
1. Use Windows Athentication. Hopefully you are doing this.
2. Create a Windows group.
3. Add all of your users into that group.
4. Grant that group datareader rights to the databases(s).
This is SQL Server Best Practice's recommendation.
August 18, 2009 at 7:38 am
I agree with RML51 - I would grant 'db_denydatawriter' as well, just to make sure. 😀
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply