Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to change Owner of a package Expand / Collapse
Author
Message
Posted Thursday, October 16, 2008 11:52 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, August 16, 2014 11:13 AM
Points: 23, Visits: 111
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
Posted Thursday, October 16, 2008 4:46 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 11:13 AM
Points: 4,064, Visits: 5,360
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
Posted Wednesday, November 5, 2008 6:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, January 9, 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 »

Add to briefcase

Permissions Expand / Collapse