Hi experts,
I would like to get a list of the missing privileges for the custom menu items. Is there any table I can get the information from?
Thanks,
Yuji,
As you mentioned the tag "Development / Customization / SDK", I do assume you are using Visual Studio. When you build your model and enable the option Run Best Practice Checks, menu items without a privilege will be listed in the output. This is also valid for data entities, without a privilege, a privilege not linked to a duty and a duty not linked to a role.
Hi Yuji, If I understand your question correctly, you want to get all custom menu items which are not associated with a Security Privilege. You can try this table 'SECURITYRESOURCEPRIVILEGEPERMISSIONS' and Data Entity 'System Security Permissions'.
Also note that in SECURITYRESOURCEPRIVILEGEPERMISSIONS table, you will find integer values in SecurableType field. In this field, value 1 is for Display menu items, 2 is for Output menu items and 3 for Action Menu Items.
You can write a x++ or SQL script to achieve your desired results.
Hi Yuji,
Do you mean looking for the standard tables that store security privilege?
Hi Yuji,
Can you elaborate your question?
Its not clear.
Thanks,
Girish S.
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156