Can we protect a portion of project?

koolnitz · Post by **koolnitz** » Thu Aug 19, 2010 10:18 am

Greetings to All !

Requirement is to restrict access/ protect/ hide a set of jobs placed under a specific category from a group of developers. Ideal would be if they can be barred to access a particular category. Even if they have Read Only access is acceptable.

Kindly let me know if there's a way to achieve this. Rendered by some business decision, two diff teams are asked to share the same project and work on their separate categories. However, there's always a risk that developers from one team mess up other team's jobs.

Thanks!

Raftsman · Post by **Raftsman** » Thu Aug 19, 2010 12:56 pm

You will need to create a separate project and put the restricted job in it. There is no facility to restrict jobs within a project

vivekgadwal · Post by **vivekgadwal** » Thu Aug 19, 2010 3:15 pm

You could export the jobs that you want, modify the dsx file to change the ReadOnly flag to 1 and re-import it. However, please keep in mind that this is a manual process and having some jobs as read-only and some without will be a little messy.

arunkumarmm · Post by **arunkumarmm** » Thu Aug 19, 2010 4:20 pm

vivekgadwal wrote:You could export the jobs that you want, modify the dsx file to change the ReadOnly flag to 1 and re-import it. However, please keep in mind that this is a manual process and having some jobs as read-only and some without will be a little messy.

But by doing this way no one will be able to edit those jobs right?

ray.wurlod · Post by **ray.wurlod** » Thu Aug 19, 2010 4:32 pm

That's right.

Jobs are records in tables, not files in directories. Therefore there's no file system permission based approach.

Currently DataStage does not include a per-job or per-category permission mechanism. As Raftsman noted the only solution is to use a different project.

vivekgadwal · Post by **vivekgadwal** » Fri Aug 20, 2010 7:16 am

arunkumarmm wrote: But by doing this way no one will be able to edit those jobs right?

Yes. I agree. I do not recommend that, but I was just suggesting a way to make them read-only in the project.

koolnitz · Post by **koolnitz** » Fri Aug 20, 2010 8:27 am

Thanks All for your responses.

We do not want to toggle the jobs between RO and RW modes, as the developers will regularly be working on their respective jobs. So, this work-around is not working for us.

As I mentioned, due to some biz decision, we can neither create separate projects.

I understand DataStage, at present, does not provide option what I had been seeking for.