Re: Security Issue in DTS package

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I mean script off the SP and remove the lines that enfore the sysadmin
restriction, then recreate.

"Anup" <Anup@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BBEB8CAD-EFCD-4FA3-952C-4097C65A2673@xxxxxxxxxxxxxxxx
> Hi Darren,
>
> What do you mean by Hacking the SP.
> Can you let me know what needs to be changed?
>
> "Darren Green" wrote:
>
>> Take you pick-
>>
>> This is a limitation of DTS/SQL, and there is no option to change this
>> restriction. Perhaps use an alternative storage location.
>>
>> Or
>>
>> Hack the sp_add_dtspackage system procedure in msdb. Unsupported, but
>> works
>> fine. I do it on all my Dev boxes for this very reason, when giving
>> developers sysadmin rights would be too much.
>>
>>
>> --
>> Darren Green
>> http://www.sqldts.com
>> http://www.sqlis.com
>>
>> "Anup" <Anup@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:855E0A88-AA37-419A-97FA-94E1E47D782D@xxxxxxxxxxxxxxxx
>> > Hi,
>> > We have a large development team and they create DTS to load some data
>> > into
>> > DEV environment and often need to change the connection properties.
>> > Since only members of sysadmin role has access to change the settings
>> > if
>> > there a way to give access to the developers so that they can modify
>> > the
>> > packages.
>> > Thanks
>>
>>
>>


.

Relevant Pages

  • Re: Logging - Best Practices
    ... it was by the developers. ... Logging packages such as java.util.logging and log4j are explicitly designed and documented to be adjusted in the field. ... different in terms of where a sysadmin would expect to look. ... would need to be passed to the common code so that it knew which log ...
    (comp.lang.java.programmer)
  • Locking down jobs in SQL Agent
    ... We are in the process of removing developers from the ... being members of sysadmin. ... except view/modify the notifications for ... perfectly able to view/modify notifications if they use QA ...
    (microsoft.public.sqlserver.security)
  • Re: top command
    ... We must understand that majority of Developers who work on multiple ... platform are addicted to Top. ... We must appreciate opensource for putting ... Not thinking as a sysadmin, we must put ourselves in the shoes of the ...
    (comp.unix.solaris)
  • Jobs, owners, and permissions
    ... I've got a question concerning permissions and jobs I was ... We have a team of application developers that are ... The developers are writing jobs that use ActiveX script ... Am I stuck with making the developers sysadmin if I want ...
    (microsoft.public.sqlserver.security)