RE: the Dts execution and the public role
From: Claudia Holzer (ClaudiaHolzer_at_discussions.microsoft.com)
Date: 09/09/04
- Next message: Andrew J. Kelly: "Re: Disk Error"
- Previous message: Sue Hoegemeier: "Re: Changing SQL Server Name"
- In reply to: ChrisR: "the Dts execution and the public role"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 9 Sep 2004 11:11:03 -0700
Yes, the user has permission to some special user database, and for the msdb
database, and I put specific permission for execute the SP
'sp_get_dtspackage', and for select the sysdtspackages table (because the Sp
make a select in this table)
"ChrisR" wrote:
> 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
> >.
> >
>
- Next message: Andrew J. Kelly: "Re: Disk Error"
- Previous message: Sue Hoegemeier: "Re: Changing SQL Server Name"
- In reply to: ChrisR: "the Dts execution and the public role"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
