DSXchange

Hello,

I am trying to retrieve user role information such as "DataStage and QualityStage User" from xmeta because the reports don't appear to provide that level of information.

I can see some of the tables which are obviously part of the answer such as ASCLMODEL_USER, ASCLMODEL_USERCREDENTIALS, ASCLMODEL_USERGROUP but I can't see how to join them up and they don't contain role information.

If looked through the posts connected with this area but I haven't found an answer.

If anyone has been successful in doing this I would be grateful if they could share the sql.

Many thanks,

Bob.

Please see my post on this topic. It's not SQL but try it out if you want to.

Hi,

I tried playing around with the same for a different reason. Maybe this post help you.