How to change Owner of a package

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » How to change Owner of a package

How to change Owner of a package

Rate Topic

Display Mode

Topic Options

Author

Message

Data9

Posted Thursday, October 16, 2008 11:52 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, January 24, 2013 8:51 PM
Points: 20, Visits: 95

I want to change owner my created packages, because on production my login may not have access.
I appreciate your quick help.
Thanks

Post #587199

Greg Charles

Posted Thursday, October 16, 2008 4:46 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 10:45 AM
Points: 4,007, Visits: 4,851

The owner of the package doesn't really matter. I'm not even sure that SSIS packages have owners. What matters is what the protection level of a package is set to and what permissions the logins in the package's connection managers have.

Greg

Post #587361

artaphi

Posted Wednesday, November 05, 2008 6:07 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 09, 2009 4:52 PM
Points: 1, Visits: 4

SSIS packages do have owners. And it does matter who the owner is. It affects security and who can or can't execute the package. Look at db_dtsltduser database role in books online.

Post #597791

« Prev Topic | Next Topic »

Permissions