Retrieving user role information from xmeta

boxtoby · Post by **boxtoby** » Thu Oct 29, 2015 3:27 am

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.

qt_ky · Post by **qt_ky** » Thu Oct 29, 2015 5:41 am

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

chanaka · Post by **chanaka** » Thu Oct 29, 2015 11:39 am

Hi,

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