How to give all permissions to Read only Datastage objects

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
suri
Participant
Posts: 24
Joined: Tue May 25, 2004 12:17 am
Location: piscataway
Contact:

How to give all permissions to Read only Datastage objects

Post by suri »

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
srimitta
Premium Member
Premium Member
Posts: 187
Joined: Sun Apr 04, 2004 7:50 pm

Post by srimitta »

TRY THIS....GOOD LUCK

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

SRIMITTA
Post Reply