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

Change SSIS package owner to SA Expand / Collapse
Author
Message
Posted Monday, April 1, 2013 12:08 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, February 27, 2014 10:41 AM
Points: 361, Visits: 1,781
Hi,Previous dba has created some SSIS package. He is the owner of the package.
Recently I joined and started using SSIS packeges without any issues.

Now network admin want to disable the previous DBA all accounts.
Question is..as long as I am logging in with my account and executing packges. I am good
Or

Do we need to change the owner to SA. If so how ? I have some 20 SSIS packages
Post #1437558
Posted Monday, April 1, 2013 12:32 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, September 15, 2014 7:19 PM
Points: 7,127, Visits: 12,655
Where are you seeing the previous DBA listed as the owner? In the properties of the SSIS package or somewhere else? Maybe in the SQL Agent jobs?

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1437568
Posted Monday, April 1, 2013 12:36 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, February 27, 2014 10:41 AM
Points: 361, Visits: 1,781
Open ssis package in BIDS
Package properties
creator name is old DBA

creator name is different than owner name?
Post #1437571
Posted Monday, April 1, 2013 1:25 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, September 15, 2014 7:19 PM
Points: 7,127, Visits: 12,655
nihal9200_kwada (4/1/2013)
Open ssis package in BIDS
Package properties
creator name is old DBA

creator name is different than owner name?

No, different. I thought that might be what you were looking at. The value of that Package property is irrelevant. You could set it to anything you like, even an empty string, and it wouldn't affect anything in terms of security during execution.

More important is that the previous DBA's Server Login does not own any databases or SQL Agent jobs.


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1437586
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse