Re: Error when run a job, which execute a DTS package

From: Mihaela M. (mihaela.mesaros_at_s-concept.net)
Date: 04/06/04 

Date: Tue, 6 Apr 2004 18:21:39 +0300

Possible to be the security settings.
So what have I do? What rights should I have to use for the object I'm
trying to create from DTS?

"DBA72" <anonymous@discussions.microsoft.com> wrote in message
news:20455D85-6DEA-42A3-95C2-7DF4AC4D4AE6@microsoft.com...
> Mihaela,
> When you run a DTS package manually, it runs under the security context of
the account you are currently logged on with. When you schedule the DTS
package, it runs under the security context of the account that SQL Server
Agent runs under.
>
> Perhaps there are differences in the rights of these two accounts.

Relevant Pages

  • Re: User Accounts
    ... account that surfs the web, and confining everything that comes down the ... Especially since folder permissions has less downside risk than filtering ... >every tool and feature in XP to lock down security as best as is possible. ... and settings do not stay the same when user account rights ...
    (microsoft.public.windowsxp.security_admin)
  • Re: User Accounts
    ... >every tool and feature in XP to lock down security as best as is possible. ... code that is exposed to the "outside", the higher the risk of exploit. ... If I limit an account in XP Home, it falls back to hiding paths, ... and settings do not stay the same when user account rights are ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Setting Permissions
    ... > Anyone with administrator rights can always over-ride such a setting. ... give rights only to the owning account. ... >> 2) Suppose there are two different operating systems on ... how will the security settings ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Cant Run Outlook Express
    ... No what MS means (and security gurus) is to not use the *hidden* ... administartor account while surfing the net. ... has a system or "hidden" administrator account that has full rights to all ...
    (microsoft.public.windowsxp.general)
  • Re: Permission
    ... I can see rights now. ... if OU has right security, some users in that OU which were in there don't ... > Your Test account should be there. ... >> Hmmm...I've never used the delegate priviledges for that purpose. ...
    (microsoft.public.windows.server.active_directory)