Making projects "Read only"

yaminids · Post by **yaminids** » Wed Jan 18, 2006 5:11 pm

Hello friends,

Can anyone please help me or direct me to posts which discuss about making existing projects read only?
I am trying to create a new user and grant him read only access so that he can monitor the jobs at night

Any help would be highly appreciated
Yamini

battaliou · Post by **battaliou** » Wed Jan 18, 2006 6:26 pm

One way of making your existing jobs read only is by messing with the dsx export file. In notepad you can do a global replace on ReadOnly "0" to be ReadOnly "1" and re import the file.

This method is of course not sanctioned by the vendors and I doubt if they would give you any support if things went wrong.

Make sure you have an alternative full backup and try it on a single test job first.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 18, 2006 6:51 pm

Is the DataStage Operator role sufficient, with the "Operator can view full log" property enabled for the project? Then you only install Director client on the person's PC (use the xxxxx-DSDIR licence rather than the xxxxx-DSDES licence).

yaminids · Post by **yaminids** » Wed Jan 18, 2006 7:09 pm

Thanks guys

chulett · Post by **chulett** » Wed Jan 18, 2006 8:56 pm

Isn't the Operator role still restricted to only viewing released jobs in the Director?

Champa · Post by **Champa** » Thu Jan 19, 2006 8:43 am

I tried with a routine. I could not import the modified routine back in to Datastage manager. It kept on saying that "Missing ReadOnly for the record ..."

kumar_s · Post by **kumar_s** » Thu Jan 19, 2006 8:52 am

Hi,

Check whether you have the value next to Readonly.
Alternatively you can try the following option in you Administrator client comand to chagne to Read only.

Code: Select all

UPDATE DS_JOBOBJECTS SET READONLY = 'RO' WHERE READONLY = 'NRO'

-Kumar

Champa · Post by **Champa** » Thu Jan 19, 2006 9:19 am

It is working fine now.

Thanks Kumar