Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
BrianYoung
Starting Member
2 Posts |
Posted - 2013-01-24 : 08:30:41
|
I want to configure a database to have permissions to allow all windows users within the windows domain to connect using Windows authentication, I have this for the sqlserver instance but not the database what is the best and simplest way to go about this.Thanks in AdvanceBrian |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-01-24 : 08:36:23
|
In Object Explorer in SSMS, under Security -> Logins, find the Domain user/group name, right-click, select properties, User Mapping tab, select the database, and grant appropriate roles.In most cases, I tend to give only public role and then explicitly grant permissions on any tables or other objects on an as needed basis. |
|
|
BrianYoung
Starting Member
2 Posts |
Posted - 2013-01-24 : 10:47:19
|
Hi James,that's great.Thanks for that.Brian |
|
|
|
|
|