开发者

SQL Server: Granting db_datawriter on all databases

开发者 https://www.devze.com 2022-12-24 11:37 出处:网络
I want to manage permissions and access to a SQL Server database server on a development machine. I\'ve created a local windows group (called DBReaderGroup) and assigned various people to it. The grou

I want to manage permissions and access to a SQL Server database server on a development machine. I've created a local windows group (called DBReaderGroup) and assigned various people to it. The group was created as a SQL Server login successfully:

create login [MYMACHINE\DBReaderGroup] fr开发者_如何学运维om windows

My goal is to grant this group read/write access to all databases (which are constantly being added and dropped). Is it possible to configure the right settings so that SQL Server manages this?

My biggest challenge is that each time a db is created, I have to update the "User Mapping" settings for this group on the new database.

Am I missing something simple?


Add the login to the Model database in the db_datawriter role, and any new database will give that login full write access by default. This won't work, however, if the databases being added are from other sources (ie restored versions).

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号