Subquestion from the question
Purpose of "NT AUTHORITY\SYSTEM" login in SQL Server 2005
discussing removal of NT AUTHORITY\System from SysAdmin group in MS SQL Server 2005.
Is my SQL Server 2008 R2 "NT AUTHORITY\SYSTEM" login is mapped
(right click on --> Properties --> User Mapping) to:
user dbo for db AdvenureWorks user "NT AUTHORITY\SYSTEM" for databases
But no mapping exists for databases
tempdb model any manually new created database AdvenureWorks2008 AdvenureWorks2008R2 AdvenureWorksDW AdvenureWorksDW2008 AdvenureWorks2008R2 AdvenureWorksLT AdvenureWorksLT2008 AdvenureWorksLT2008R2
Why such mapping was created for AdvenureWorks but not all other sample databases and newly created databases?
Why does ReportServerTempDB requires mapping but not tempdb?
View Complete Post