NCM Roles for Auditing Export / Orion SDK

You can find out the NCM role defined for all users with this query:

SELECT AccountID, SettingValue

FROM Orion.WebUserSettings

WHERE SettingName='NCM.NCMAccountRole'

thanks for that, after your answer I found the settings I was looking for also in the Schema Description.

Hello,

I am looking to do something similar, but I need all users and their Account Limitations. Does anyone knows where to find it in DB. In the WebUserSettings I couldn't find the Limitation for each account like the NCMaccount Role.

Any help will be appreciated.

Thanks,

Antonis

Orion users can be found in Orion.Accounts. Each account has (up to) three limitations referenced by the LimitationID[1-3] properties. Definitions for those limitations are found in Orion.Limitations.

Yes.. actually after I posted the question I found the tables.

Thanks,

Antonis