I have a couple of databases that are occasionally deleted and recreated. This happens when the schema changes.
I have a group of developers that need access to those databases. In order to grant these developers access to those databases, I can either:
Use a shared login, and grant that login access to each database using SSMS. This is bad security, but fairly quick. I don't want to do this except that it saves me a lot of time.
Use individual logins, and grant each individual login access to each database using SSMS. This is good security, but costs me time every time I have to recreate the databases. I have to select each user's login, and edit the user's User Mapping.
How can I easily grant a group of users access to a database that I've dropped and recreated?
Microsoft SQL Server Management Studio 12.0.2569.0
- There are about six developers.
- There are two SqlServer servers.
- Each server has two databases to which developers are granted access.
- Databases are deleted/recreated once or twice a month.