How to grant a user the rights to access to all new (future) databases? 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.
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.