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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 2008 R2 Permissions

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 Advance
Brian

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.
Go to Top of Page

BrianYoung
Starting Member

2 Posts

Posted - 2013-01-24 : 10:47:19
Hi James,

that's great.

Thanks for that.

Brian
Go to Top of Page
   

- Advertisement -