SequelDBA (10/1/2009)
If a program requires a login with the SYSADMIN role and rights to Master, will a login with the SYSADMIN role have rights to MASTER by default or does that have to be granted?
And login which is a member of the sysadmin role has all rights everywhere on a particular instance of SQL Server. Those rights are implicit. Basically, being a member of the sysadmin server role means the login ignores all security checks. So yes, it does.
K. Brian Kelley
@kbriankelley