SQL Query in Compass for OS Security?

michael-hagen

Hello,

I was wondering if there is a way that I could query our user security setups in Compass or using SQL in any way? Looking in Compass I don't see anything about user security. I thought it may be my access but we don't have data security enabled (we don't typically use SQL here in any way).

Kevin Heiman

Hi Hichael,
Encourage you to move to the Infor OS Platform communities forum on https://developer.infor.com/
https://community.developer.infor.com/categories/infor-os-platform

Auditing and Monitoring can provide some of what you may need.  It can be configured to publish to Data Lake.

Infor GRC will soon support publishing data and insights to Data Lake as well.

Other possibilities are APIs and BODs.   Depends on requirements and what security data you desire.