We are doing a new MS SQL and BI setup for our developers here.
We have a team of 12 developers here doing different projects. We have one server with MS SQL being installed. This single MS SQL will be setup with each individual database for the projects that the 12 person will be doing.
We plan have all the 12 developers connect to their database in this server and develop their ssis packages in their local PCs. We want to restrict them to be able to access the packages that belongs to their projects only.
Also after deployment where the packages are scheduled to run under job agent, we want to restrict each 12 developers to be able to rerun only their on jobs when their job fails. We want to prohibit them from running the jobs that belongs to others.
I think this is a pretty common organization structure with a team of developers. However I have no experience how we should structure and control our MS SQL and the BID.
I would appreciate if you can advice. Our team has been thinking of the best solution but I guess we are confuse now.
Now our problem is to know how
Software/Hardware used: MS SQL 2008 Standard Edition