How can I map a Windows group login to the dbo schema in a database?
- by Christian Hayter
I have a database for which I want to restrict access to 3 named individuals. I thought I could do the following:
Create a local Windows group on the database server and add the named individuals to it.
Create a Windows login in SQL Server mapped to the local Windows group.
Map the login to the "dbo" schema in the database, so that the users can…