Permissions on DataStage Category ?

[kaps]

How can I enforce permissions on DataStage Category ?
I could not find a way to do this...Say I have a folder with reusable jobs and I don't want others to change those reuable jobs. How can I accomplish this ? Any hint is appreciated.

Thanks

[kcbland]

There's no way, security is at a project level. You can mark jobs as read-only using the version control tool or manually updating the repository.

[ogmios]

I've been playing a lot with DataStage security, security on categories is not possible.

To make jobs read-only use something as:

Code: Select all

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

To make shared containers read-only:

Code: Select all

UPDATE DS_CONTAINERS SET READONLY = 'RO' WHERE READONLY = 'NRO';

For transforms, table definitions, ... you all need other statements, if needed I can probably still find them somewhere.

Ogmios

[kaps]

Thanks for the replies

[kumar_s]

Alternativly you can try to make readonly particular to category as follows.

Code: Select all

UPDATE DS_JOBOBJECTS SET READONLY = 'RO' WHERE READONLY = 'NRO' AND NAME IN (SELECT NAME FROM DS_JOBS WHERE CATEGORY LIKE '%xxxxx%')

Where the category is what need to converted.