Getting security permissions from an external data source
I have a database that is accessing an external data source. I will call the external source "Data" and the local database "Local".
When Local launches, it signed into a "Standard" user. I restricted all edit access to menus, layouts, scripts, etc. The Data file has multiple privilege sets: Admin, Manager, Employee, etc.
What I'm looking to do is further restrict the Local file. For instance, there is a pop up that allows managers to view and edit hours worked. I only want the Manager privilege set to be able to view. For the Employee set, I'd want something that displays a message.
Is there a command or get feature that can access the external source's security groups?
Thanks in advance.