question

sc5502 avatar image
sc5502 asked

How to add All users to a database

Background: MS SQL Server 2008 and MS SQL Server Management Studio 2014 I am new to MS SQL Server so please bear with me. I have just created a database(MyDatabase) that has two tables (tables AAA and BBB). All users have the need to read and write to both tables.. All of the users are defined to SQL Server. How can I grant access these users to my database without having to add all of them to the database individually?
add
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
JohnM avatar image
JohnM answered
My advice would be to put them in a domain group and create a login in SQL Server for the domain group. Then you can create a database user for that login and assign permissions accordingly. This way group membership is set at the domain (active directory) level and you don't have to try to manage it within SQL Server. https://www.mssqltips.com/sqlservertip/1831/using-windows-groups-for-sql-server-logins-as-a-best-practice/ Hope that helps!
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.