Re: disable guest account in MSDB

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 08/03/04 

Date: Mon, 02 Aug 2004 18:22:31 -0600

Generally things would be okay but it depends on if you have
anything setup or configured that relies on users gaining
access to msdb through the guest account. You'd need to
assess that based on your databases, apps, etc. Removing
guest from msdb means that users would need be granted
access to msdb in order to execute or access anything that
the guest account access through permissions via the public
role.

-Sue

On Mon, 2 Aug 2004 06:55:05 -0700, "Javier Herrera P."
<Javier Herrera P.@discussions.microsoft.com> wrote:

>I'm trying to enforce DTS package managment security in an
>Enterprise Enviroment. Microsoft has published KB Article 282463
>related, recommending disable guest account in msdb. But,
>what it's the impact of doing that? it's just a simple
>"execute sp_revokedbaccess 'guest'" ?? will everything continue
>functioning normally?
>
>Thanks
>-------------------
>Javier Herrera P.
>MCDBA - OCP
>SQL*Technology
>Santiago - Chile
>-------------------

Relevant Pages

  • Re: ok to remove guest from msdb?
    ... I usually remove guest from msdb, but to be more certain before posting this I asked around my MVP ... and MCT colleagues. ...
    (microsoft.public.sqlserver.server)
  • Looking at DTS Local Packages
    ... assume this is because msdb has a guest id and it is in the public role ... which has explicit access to a number of objects in msdb. ... If either guest ... this cause a problem with running DTS local packages on a server? ...
    (microsoft.public.sqlserver.tools)
  • Looking at DTS Local Packages
    ... assume this is because msdb has a guest id and it is in the public role ... which has explicit access to a number of objects in msdb. ... If either guest ... this cause a problem with running DTS local packages on a server? ...
    (microsoft.public.sqlserver.server)