×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

DTS Saved with Wrong Owner?

DTS Saved with Wrong Owner?

DTS Saved with Wrong Owner?

(OP)
I am the DBA for one of our SQL 2000 Servers.  I created a DB Role in MSDB to allow execute permissions on all SP's related to DTS creation/modification/dropping, etc, then granted access for a couple SQL ID's and a Network ID to that Role.

When the user opens and resaves a current DTS package, no matter which ID he uses to save it (his network ID, or the SQL ID's), the package is saved with having my network ID as the owner of the package.  No matter if I reset it back to his, or the SQL ID's, this continues to happen.

Does anyone know what may be causing this?  I thought whoever saves the package is set as the owner. (?)

  -Ovatvvon          licking face

RE: DTS Saved with Wrong Owner?

(OP)
Nevermind, I found the answer.

Apparently, for SQL 2000, whoever originally saves a DTS package on a SQL Server will be the owner indefinately.  Even if you change the owner of the package, once it is saved again, the owner automatically reverts back to its original ID.

Only way to resolve was to set owner as user; have user save as another name; delete current package; have user open the package with the new name and save with the original name; then delete the package with the new name, and keep the package that now as the original name.

Alternatively, I was able to just give the user sufficient execute permissions on specific MSDB stored procedures, and they were able to alter the packages even if my ID remained as owner.  This is sufficient, so we did not bother going through the entire process above for all 67 dts packages.  smile

  -Ovatvvon          licking face

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close