guest user in msdb

From: maria (mariaisabelguzman@icasa.com.gt)
Date: 04/22/03


From: "maria" <mariaisabelguzman@icasa.com.gt>
Date: Tue, 22 Apr 2003 11:22:24 -0700


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.



Relevant Pages

  • RE: Recover SQL files & DST packages from server backup
    ... > after you install the OEM copy on the SBS box. ... If the DTS Packages are saved to SQL Server, they would be saved in the ... > sysdtspackages table in the SQL Server msdb database. ...
    (microsoft.public.windows.server.sbs)
  • Re: Very Very Urgent, Please Help
    ... does your packages are stored in the MSDB database? ... Have you changed your main package to use the right SQL Server instance? ... When my main dts package calls other dts packages getting timeout immediately. ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Cannot See DTS Package Created
    ... What rights do you have in msdb database? ... > DTS packages but cannot see them in the SQL Server 2000 Enterprise ... After the new registered SQL Server with Windows only I ...
    (microsoft.public.sqlserver.dts)
  • where is my DTS package?
    ... i can't find out where does the sql server save my DTS packages. ... that there is something in the msdb DATABASE about DTS but i couldn't find my ... Prev by Date: ...
    (microsoft.public.sqlserver.dts)
  • RE: Recover SQL files & DST packages from server backup
    ... Move Databases Between Computers That Are Running SQL Server ... In order to backup and restore the DTS Packages, it depends on how they are ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)