How to grant a user the rights to access to all new (future) databases?

Question

On my development machine, I often create new web instances that all run as NT AUTHORITY\NETWORK SERVICE. I want to grant this account rights to access all new databases that I create in the future in my SQL Server 2008 R2 instance. I want to do this because it is too much of a hassle to grant rights to new databases every time I create a new web site.

@Kin This works. Should I remove the question? – Dmytro Shevchenko Sep 17 '15 at 15:00 — Dmytro Shevchenko, Sep 17 '15 at 15:00
Please leave it .. no need to delete. Thanks ! – Kin Shah Sep 17 '15 at 15:24 — Kin Shah, Sep 17 '15 at 15:24

score 1 · Accepted Answer · edited Apr 13 '17 at 12:42

1

Well - there is a bigger question regarding why you are using NT Authority\Network, but I asked a similar question ages ago Permissions on New Databases So in theory, it is fairly simple.

edited Apr 13 '17 at 12:42

Community

1

answered Sep 17 '15 at 14:53

rottengeek

690
6
17

Thank you, I'm checking out the other question. Is there any problem with using NETWORK SERVICE as the identity of my IIS application pools? – Dmytro Shevchenko Sep 17 '15 at 14:56

How to grant a user the rights to access to all new (future) databases?

1 Answers1