Re: Viewing DTS package properties and Permissions

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 07/31/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Tue, 30 Jul 2002 17:33:41 -0600

Yes...I'm aware of that. Depends on if there is a need for
the consultant to have access to msdb for other reasons.
Could get rather convoluted going through all the
possiblities which is why I only said it was an option.

-Sue

On Tue, 30 Jul 2002 19:26:37 -0400, "BP Margolin"
<bpmargo@attglobal.net> wrote:

>Sue,
>
>While your suggestion is a good first step, it would not defeat a consultant
>who knows that DTS packages are stored in the msdb database.
>
>Perhaps addressing the permissions of the msdb database provides additional
>protection.
>
>-------------------------------------------
>BP Margolin
>Please reply only to the newsgroups.
>When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
>can be cut and pasted into Query Analyzer is appreciated.
>
>"Sue Hoegemeier" <Sue_H@nomail.please> wrote in message
>news:huvdkuo0hhrte44aaik5hchqaee3gs02v7@4ax.com...
>> Another option would be to deny execute permissions on
>> sp_enum_dtspackages.
>>
>> -Sue
>>
>> On Tue, 30 Jul 2002 12:24:06 -0700, "TO" <cto@aifs.com>
>> wrote:
>>
>> >That would not be practical for development reason as well
>> >as for versioning purposes (assuming that I will have to
>> >save new and lose all the previous versions). Besides, I
>> >have so many packages, to re-save them just won't be easy.
>> >
>> >
>> >>-----Original Message-----
>> >>Easiest is probably to use a password when you save it
>> >>
>> >>HTH
>> >>Jasper Smith
>> >>
>> >>"TO" <cto@aifs.com> wrote in message
>> >>news:2e0601c237fa$6562a330$9ae62ecf@tkmsftngxa02...
>> >>> I gave user permission "consultant" to my consultant on
>> >>> one of the databases. If I need to put security to
>> >prevent
>> >>> consultant from viewing/modifying my dts packages, how
>> >can
>> >>> achieve that?
>> >>
>> >>
>> >>.
>> >>
>>
>