DTS Protection

I'm trying to protect a package... using an owner password.
After I create an owner password and generate a dts command line from
DTSRunUI... it puts the package password in the string.
Basically if someone goes into the job and looks at this line they have the password to open the package...

DTSRun /S "svr-eqanalysis" /N "OrgExtract Rename" /M "password" /G "{2E2B6F07-0E56-4212-A894-B85A4EAA6C8C}" /W "0" /E

We can not remove the builtin administrators group from the machine
therefore system admins that want to poke around into our work can do so...
any suggestions.....

thanks,

jonathanRight click on the package, and select schedule. SQL Server automatically encrypts the whole command line for you. You may have to recover this from the job itself.|||Perfect.... !!!
thank you.....
jonathan|||Mcrowley
How would one stop a person from messing with the sql server agent... under the same circumstances...
stopping from someone changing a particular job...
more then one dba or system admin has a job
you want to secure just your job from others...
possible... ?

DTS Package Owner

I have to modify the DTS package owner that is displayed in the local
packages view, the current owner no longer works for the company so I need
to reassign ownership. I am not a sql expert by any means.
Can anyone help me with this?
It is SQL Server 2000 sp4 running on Windows 2003 sp1.
Paul Bergson
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
Paul - please take a look here: http://www.sqldts.com/default.aspx?212
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||This is what I was looking for.
Thanks
Paul Bergson
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ulsvIajEHHA.992@.TK2MSFTNGP03.phx.gbl...
> Paul - please take a look here: http://www.sqldts.com/default.aspx?212
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>

DTS Package Owner

Hello there,

Im trying to change the owership of the DTS package but am a little
confused.

sp_changeobjectowner changes the ownership of table, view, or stored
procedure in the current database...

How could i change the DTS package ownership?

Thank you in advance.

Leo

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!Leo Kozhushnik <anonymous@.devdex.com> wrote in message news:<3f1390c1$0$202$75868355@.news.frii.net>...
> Hello there,
> Im trying to change the owership of the DTS package but am a little
> confused.
> sp_changeobjectowner changes the ownership of table, view, or stored
> procedure in the current database...
> How could i change the DTS package ownership?
> Thank you in advance.
> Leo

In most cases, it doesn't really matter who owns the package - who is
executing it is more important. However, there is an undocumented
stored procedure called msdb..sp_reassign_dtspackageowner, which you
can use.

You might want to look at http://www.sqldts.com - in the
Administration and Management section of the FAQ, there is an article
on package ownership issues, including a wrapper procedure for
sp_reassign_dtspackageowner.

Of course, since this procedure is undocumented, you should be careful
using it, and preferably never in production code - its behaviour may
change in future releases with no warning.

Simon|||Leo Kozhushnik <anonymous@.devdex.com> wrote in message news:<3f1390c1$0$202$75868355@.news.frii.net>...
> Hello there,
> Im trying to change the owership of the DTS package but am a little
> confused.
> sp_changeobjectowner changes the ownership of table, view, or stored
> procedure in the current database...
> How could i change the DTS package ownership?
> Thank you in advance.
> Leo
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

Hi Leo, use the undocumented SP:

sp_reassign_dtspackageowner [@.name =] 'name',
[@.id =] 'id',
[@.newloginname =] 'newloginname'

[@.name =] 'name'
The package name.

[@.id =] 'id'
This is the uniqueidentifier for the package. A name may not
necessarily be unique.

[@.newloginname =] 'newloginname'
The new Owner name. SQL Server login example 'sa', NT Integrated
example 'Domain\Username'

Regards,
Thomas
http://www.sqlscripter.com

DTS Package Owner

I have to modify the DTS package owner that is displayed in the local
packages view, the current owner no longer works for the company so I need
to reassign ownership. I am not a sql expert by any means.
Can anyone help me with this?
It is SQL Server 2000 sp4 running on Windows 2003 sp1.
--
Paul Bergson
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.Paul - please take a look here: http://www.sqldts.com/default.aspx?212
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||This is what I was looking for.
Thanks
--
Paul Bergson
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ulsvIajEHHA.992@.TK2MSFTNGP03.phx.gbl...
> Paul - please take a look here: http://www.sqldts.com/default.aspx?212
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>

DTS Package Owner

I have to modify the DTS package owner that is displayed in the local
packages view, the current owner no longer works for the company so I need
to reassign ownership. I am not a sql expert by any means.
Can anyone help me with this?
It is SQL Server 2000 sp4 running on Windows 2003 sp1.
Paul Bergson
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.Paul - please take a look here: http://www.sqldts.com/default.aspx?212
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .|||This is what I was looking for.
Thanks
Paul Bergson
http://www.pbbergs.com
Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:ulsvIajEHHA.992@.TK2MSFTNGP03.phx.gbl...
> Paul - please take a look here: http://www.sqldts.com/default.aspx?212
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>

DTS owner password

Hi,
Can i assign a owner password to a especified package
without recreating the package ?
Thanks a lot
MikeHI,
Open the Package and use the option SAVE AS and provide the Owner password.
In this case you will need to give a new name for this package.
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:14e5801c41c8e$87f3eba0$a001280a@.phx
.gbl...
> Hi,
> Can i assign a owner password to a especified package
> without recreating the package ?
> Thanks a lot
> Mike|||There's no other option ' I don't want to rename my
DTS's, i have references to it.

>--Original Message--
>HI,
>Open the Package and use the option SAVE AS and provide
the Owner password.
>In this case you will need to give a new name for this
package.
>Thanks
>Hari
>MCDBA
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
> news:14e5801c41c8e$87f3eba0$a001280a@.phx
.gbl...
>
>.
>|||You can but you need to be careful with it.
Open up the package and leave the window open. Then go back
to Enterprise Manager (with the package window still open)
and delete the package in Enterprise Manager. Now the
package will be available in memory from having the window
open but you will be able to Save As with the same name as
you just deleted the package in Enterprise Manager. Now go
back to the package window you have open and do the save as
with the password and you won't need to change the package
name.
In terms of the references to it, if you have any execute
package tasks that are calling this package, they will have
problems as the save as changes the GUID for the package
which is what the execute package tasks typically bind to in
referencing the other packages it executes.
-Sue
On Wed, 7 Apr 2004 04:24:22 -0700, "Mike"
<anonymous@.discussions.microsoft.com> wrote:
>There's no other option ' I don't want to rename my
>DTS's, i have references to it.
>
>the Owner password.
>package.
>message

DTS owner password

Hi,
Can i assign a owner password to a especified package
without recreating the package ?
Thanks a lot
Mike
HI,
Open the Package and use the option SAVE AS and provide the Owner password.
In this case you will need to give a new name for this package.
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:14e5801c41c8e$87f3eba0$a001280a@.phx.gbl...
> Hi,
> Can i assign a owner password to a especified package
> without recreating the package ?
> Thanks a lot
> Mike
|||There's no other option ? I don't want to rename my
DTS's, i have references to it.

>--Original Message--
>HI,
>Open the Package and use the option SAVE AS and provide
the Owner password.
>In this case you will need to give a new name for this
package.
>Thanks
>Hari
>MCDBA
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
>news:14e5801c41c8e$87f3eba0$a001280a@.phx.gbl...
>
>.
>
|||You can but you need to be careful with it.
Open up the package and leave the window open. Then go back
to Enterprise Manager (with the package window still open)
and delete the package in Enterprise Manager. Now the
package will be available in memory from having the window
open but you will be able to Save As with the same name as
you just deleted the package in Enterprise Manager. Now go
back to the package window you have open and do the save as
with the password and you won't need to change the package
name.
In terms of the references to it, if you have any execute
package tasks that are calling this package, they will have
problems as the save as changes the GUID for the package
which is what the execute package tasks typically bind to in
referencing the other packages it executes.
-Sue
On Wed, 7 Apr 2004 04:24:22 -0700, "Mike"
<anonymous@.discussions.microsoft.com> wrote:
>There's no other option ? I don't want to rename my
>DTS's, i have references to it.
>
>the Owner password.
>package.
>message

DTS owner password

Hi,
Can i assign a owner password to a especified package
without recreating the package ?
Thanks a lot
MikeHI,
Open the Package and use the option SAVE AS and provide the Owner password.
In this case you will need to give a new name for this package.
Thanks
Hari
MCDBA
"Mike" <anonymous@.discussions.microsoft.com> wrote in message
news:14e5801c41c8e$87f3eba0$a001280a@.phx.gbl...
> Hi,
> Can i assign a owner password to a especified package
> without recreating the package ?
> Thanks a lot
> Mike|||There's no other option ' I don't want to rename my
DTS's, i have references to it.
>--Original Message--
>HI,
>Open the Package and use the option SAVE AS and provide
the Owner password.
>In this case you will need to give a new name for this
package.
>Thanks
>Hari
>MCDBA
>"Mike" <anonymous@.discussions.microsoft.com> wrote in
message
>news:14e5801c41c8e$87f3eba0$a001280a@.phx.gbl...
>> Hi,
>> Can i assign a owner password to a especified package
>> without recreating the package ?
>> Thanks a lot
>> Mike
>
>.
>|||You can but you need to be careful with it.
Open up the package and leave the window open. Then go back
to Enterprise Manager (with the package window still open)
and delete the package in Enterprise Manager. Now the
package will be available in memory from having the window
open but you will be able to Save As with the same name as
you just deleted the package in Enterprise Manager. Now go
back to the package window you have open and do the save as
with the password and you won't need to change the package
name.
In terms of the references to it, if you have any execute
package tasks that are calling this package, they will have
problems as the save as changes the GUID for the package
which is what the execute package tasks typically bind to in
referencing the other packages it executes.
-Sue
On Wed, 7 Apr 2004 04:24:22 -0700, "Mike"
<anonymous@.discussions.microsoft.com> wrote:
>There's no other option ' I don't want to rename my
>DTS's, i have references to it.
>
>>--Original Message--
>>HI,
>>Open the Package and use the option SAVE AS and provide
>the Owner password.
>>In this case you will need to give a new name for this
>package.
>>Thanks
>>Hari
>>MCDBA
>>"Mike" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:14e5801c41c8e$87f3eba0$a001280a@.phx.gbl...
>> Hi,
>> Can i assign a owner password to a especified package
>> without recreating the package ?
>> Thanks a lot
>> Mike
>>
>>.

DTS owner

How do I change the DTS owner? Thanks.Check the following article on sqldts.com:
Package Ownership Issues
http://www.sqldts.com/default.aspx?212
-Sue
On Mon, 24 Nov 2003 08:58:22 +0800, "supernova"
<abc@.yahoo.com> wrote:
>How do I change the DTS owner? Thanks.
>