topic Combining Check-in-Check-out (CiCo) and the ability to deploy jobs? in Administration and Deployment

Combining Check-in-Check-out (CiCo) and the ability to deploy jobs?

FrankPoppe — Mon, 20 May 2019 20:00:02 GMT

Hi,

In general I am a supporter of using the check-in-check-out (CiCo) authorization mechanism when a group of developers is working together in a project.

But an always occurring nuisance is that when developers only have the CiCo metadata rights they cannot deploy jobs (that requires WriteMetadata rights on some objects).

There does not seem to be a way to give developers just those rights they need to deploy jobs, without making possible the kind of accidents that you try to prevent with CiCo.

Or is there a way?

Do others experience the same problem?

Is this something for a feature request?

Thanks!

Re: Combining Check-in-Check-out (CiCo) and the ability to deploy jobs?

VDD — Mon, 20 May 2019 22:18:35 GMT

one way to handle that is to create developer user accounts and production user accounts.

Re: Combining Check-in-Check-out (CiCo) and the ability to deploy jobs?

Kurt_Bremser — Tue, 21 May 2019 07:45:44 GMT

You can solve this problem by having a separate "Deploy" authority whose members handle that step.

In our case, the final development step (putting jobs into production) is handled (upon web-based request) by the datacenter people who also control the scheduling. We (the developers) have authority only to move the codes up to the pre-production stage.

Mind that we do not use SAS scheduling, but keep our codes in SVN and have the jobs defined and run in Control-M.

Re: Combining Check-in-Check-out (CiCo) and the ability to deploy jobs?

FrankPoppe — Wed, 26 Jun 2019 19:25:51 GMT

It seems the environment I usually encounter is different, on two aspects:

Often single-signon is the only way developers can log on to the SAS metadata, which excludes the use of a separate identity.
Usually the developers are responsible for deploying jobs and creating the package to promote something from the develop environment.

That is why I was looking for a way to combine CiCo with deploying. But it seems that is not possible without a change in the SAS metadata setup...