Re: guest user in msdb

From: news@news.com
Date: 04/22/03

  • Next message: Mary Bray: "Failed to copy table objects - DTS Wizard" 
    From: <news@news.com>
Date: Tue, 22 Apr 2003 13:35:37 -0700

    better to revoke on that proc:

    use msdb
    REVOKE EXECUTE on sp_add_dtspackage FROM PUBLIC

    "maria" <mariaisabelguzman@icasa.com.gt> wrote in message
    news:056201c308fc$1f009ae0$3401280a@phx.gbl...
    hi, i am having problems with some users that are creating
    dts packages and i donīt want that this users have
    permissions to create it.

    I investigated and found that i can remove the guest user
    in the msdb database. I would appreciate if someone know
    if i this change can cause problems in sql server.

    Thanks a lot.

  • Next message: Mary Bray: "Failed to copy table objects - DTS Wizard"

    Relevant Pages

    • Re: Help! Are my DTS Packages gone for good?
      ... If you save the DTS packages as VB files, ... they are gone after msdb is ... > connect to my own SQL Server running on my own workstation. ... I just reattached them after reinstalling. ...
      (microsoft.public.sqlserver.dts)
    • Re: Help! Are my DTS Packages gone for good?
      ... If you save the DTS packages as VB files, ... they are gone after msdb is ... > connect to my own SQL Server running on my own workstation. ... I just reattached them after reinstalling. ...
      (microsoft.public.sqlserver.server)
    • Re: Help! Are my DTS Packages gone for good?
      ... If you save the DTS packages as VB files, ... they are gone after msdb is ... > connect to my own SQL Server running on my own workstation. ... I just reattached them after reinstalling. ...
      (microsoft.public.sqlserver.setup)
    • Re: Restore DTS packages
      ... this database you can restore that. ... but instead of copying the msdb to a new location, ... > I have uninstalled a MSDE version but there were some DTS packages on it. ...
      (microsoft.public.sqlserver.dts)
    • RE: DTS permissions to create
      ... There's no specific stored procedure in msdb that I can ... >You could try revoking or denying write permissions to ... >> creating DTS packages on a SQL 2000 server? ...
      (microsoft.public.sqlserver.server)
    • Quantcast