Hi,
Can any one explain how to give all permissions to the read only Datastage Objects ?
I used below commands to make DS_OBJECTS read only.
Job designs
Code:
UPDATE DS_JOBOBJECTS SET READONLY = 'RO' WHERE READONLY = 'NRO';
Routines
Code:
UPDATE DS_ROUTINES SET READONLY = 'RO' WHERE READONLY = 'NRO';
Transforms
Code:
UPDATE DS_TRANSFORMS SET READONLY = 'RO' WHERE READONLY = 'NRO';
Data Elements
Code:
UPDATE DS_DATATYPES SET READONLY = 'RO' WHERE READONLY = 'NRO';
Table Definitions
Code:
UPDATE DS_METADATA SET READONLY = 'RO' WHERE READONLY = 'NRO';
Shared Containers
Code:
UPDATE DS_CONTAINERS SET READONLY = 'RO' WHERE READONLY = 'NRO';
Now i want Give Read Write options to DS_Objects.
Thanks
Suresh
How to give all permissions to Read only Datastage objects
Moderators: chulett, rschirm, roy