Wednesday, March 28, 2012

ok to remove guest from msdb?

BOL says "The guest user can be deleted and added to all databases
except master and tempdb, where it must always exist."
any reason for guest to be in msdb?I usually remove guest from msdb, but to be more certain before posting this
I asked around my MVP
and MCT colleagues. No one has experienced any bad effect from removing gues
t from msdb. Of course,
for a non-sysadmin to create jobs etc, you need to add that login to msdb, b
ut the fact that you now
can control who can do what is a good thing, IMO (and might just be why you
posted this in the first
place :-) ).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"ch" <ch@.dontemailme.com> wrote in message news:41862F84.647BCB04@.dontemailme.com...eagreen">
> BOL says "The guest user can be deleted and added to all databases
> except master and tempdb, where it must always exist."
> any reason for guest to be in msdb?

No comments:

Post a Comment