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
Permissions on DataStage Category ?
Moderators: chulett, rschirm, roy
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.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
I've been playing a lot with DataStage security, security on categories is not possible.
To make jobs read-only use something as:
To make shared containers read-only:
For transforms, table definitions, ... you all need other statements, if needed I can probably still find them somewhere.
Ogmios
To make jobs read-only use something as:
Code: Select all
UPDATE DS_JOBOBJECTS SET READONLY = 'RO' WHERE READONLY = 'NRO';
Code: Select all
UPDATE DS_CONTAINERS SET READONLY = 'RO' WHERE READONLY = 'NRO';
Ogmios
In theory there's no difference between theory and practice. In practice there is.
Alternativly you can try to make readonly particular to category as follows.
Where the category is what need to converted.
Code: Select all
UPDATE DS_JOBOBJECTS SET READONLY = 'RO' WHERE READONLY = 'NRO' AND NAME IN (SELECT NAME FROM DS_JOBS WHERE CATEGORY LIKE '%xxxxx%')
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'