Datastage permissions question

mak · Post by **mak** » Tue Apr 26, 2005 2:00 pm

Is there a way to set up an user in datastage so as to just view logs in director and not run the jobs.

I checked the documentation it only mentioned 4 user categories-developer,production manager,operator,None but none of these 4 are helpful for the above mentioned permission.

Thanks

kcbland · Post by **kcbland** » Tue Apr 26, 2005 2:02 pm

kduke · Post by **kduke** » Tue Apr 26, 2005 3:50 pm

You would have to do some programming tricks. I wrote a job to email you the log file of any job. You could automatically run this at the end of a sequence for every job in the sequence. It is part of EtlStats. You can download this from my tips page.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Apr 27, 2005 4:38 am

What about giving the users the director priviledge but do not say the important user/pass info (apart from those required to login to DS Server).

kcbland · Post by **kcbland** » Wed Apr 27, 2005 9:21 am

Sainath.Srinivasan wrote:What about giving the users the director priviledge but do not say the important user/pass info (apart from those required to login to DS Server).

No, the server login is the DataStage user login. There are no abilities within DataStage to do what was asked. You can setup programmatic solutions that would allow you to do certain things, but this is soooo messy I will not even attempt to explain how to do it.

Kim's suggestion is a viable option, export the log information programmatically to a third party such as a database. But, the question asked was not for a work-around, it was for inherent capability.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Apr 27, 2005 12:31 pm

I know that DS user/pass is the underlying Server Os's user/pass. My idea was something like avoiding the people the db, network user/pass in order to avoid processing.

trokosz · Post by **trokosz** » Wed Apr 27, 2005 7:34 pm

The answer given saying "NO" is the right one. You can build a Routine to email you the Log as a attachment or place on a server thats accessible by all developers. Ascential has no plans at this time to provide a Log Viewer only.