the Dts execution and the public role

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: ChrisR (anonymous_at_discussions.microsoft.com)
Date: 09/09/04 

Date: Thu, 9 Sep 2004 09:40:44 -0700

Can you assign specific permissions to specific users for
this scenario?

>-----Original Message-----
>I have some application in Visual Basic 6, and I create a
DTS in my local
>machine (my local SQl Server), and when I try to execute
the DTS from the
>application I have no problems , but when I put this DTs
in some remote SQL
>server, and then I try to execute my application, I
obtain this message:
>EXECUTE permission denied on object 'sp_get_dtspackage',
database msdb,
>owner 'dbo'
>I when I review I can see that the problem is because I
denied the
>privileged for this SP to a public role (if I simple take
out the denied I
>have no problem).
>I don't like to take out this 'denied' to the public
role, because it can be
>dangerous, I like to know if I have another way to
resolve this. Thanks
>.
>

Relevant Pages

  • Dts execution and the public role
    ... I have some application in Visual Basic 6, and I create a DTS in my local ... machine (my local SQl Server), and when I try to execute the DTS from the ... I don't like to take out this 'denied' to the public role, ...
    (microsoft.public.sqlserver.dts)
  • the Dts execution and the public role
    ... I have some application in Visual Basic 6, and I create a DTS in my local ... machine (my local SQl Server), and when I try to execute the DTS from the ... I don't like to take out this 'denied' to the public role, ...
    (microsoft.public.sqlserver.server)
  • Re: Is that OK to run a windows application using a DTS task?
    ... through DTS and the form came up. ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > execute a windows application which have a user interface awaitting user ...
    (microsoft.public.sqlserver.dts)
  • RE: Executing Looping SP within DTS (SP provided)
    ... I haven't included the DTS Package. ... Package simply runs this procedure using execute sql task. ... INNER JOIN tbl_country cty ... --- Now load volume data by comparing the two months cumulative totals ...
    (microsoft.public.sqlserver.dts)
  • Re: delete some user from the public role
    ... really my problem is related with a DTS execution. ... and when I try to execute the DTS from the ... I don't like to take out this 'denied' to the public role, ... > Jasper Smith (SQL Server MVP) ...
    (microsoft.public.sqlserver.security)