Page 1 of 1
Permissions on DataStage Category ?
Posted: Tue Apr 18, 2006 12:51 pm
by 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
Posted: Tue Apr 18, 2006 12:54 pm
by 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.
Posted: Tue Apr 18, 2006 3:54 pm
by 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
Posted: Wed Apr 19, 2006 9:06 am
by kaps
Thanks for the replies
Posted: Thu Apr 20, 2006 1:23 am
by 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.