quote:
Would it be a good idea to add guest to db_denydatawriter role in master database?! I wanted to feel safe with that account being there.
Guest does not have permissions to write to any tables or views. Every user that isn't explicitly mapped to a user in master (which would be everybody by default... and there's not usually a reason to add a login as a user to master) comes in as guest. Guest is required in master and tempdb.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley