Timeline for How do I create "groups of users" and set permissions in SQL Server?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 11, 2021 at 18:32 | vote | accept | Felix An | ||
| May 11, 2021 at 18:32 | comment | added | Felix An | This is great; thanks so much! | |
| May 11, 2021 at 11:42 | comment | added | J.D. |
@FelixAn Note that if you are using Active Directory, then you can either create a LOGIN per individual User or just create a LOGIN per Active Directory Group that those Users already belong to. Presumably you'd only need two Active Directory Groups here for a total of two LOGINs, one for the more restrictive permissions and one for the less restrictive permissions. You can even use one of the existing Active Directory Groups like [Domain Users] if you wanted to assign default permissions for all Users on the domain.
|
|
| May 11, 2021 at 11:16 | history | answered | Dan Guzman | CC BY-SA 4.0 |