Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Unanswered

Security Filter in permission set on table 2000000006 doesn't work anymore

Posted on by 2
Hi all,
 
Previously, I had success with using the Exclude and Include permissions in a permission set in Business Central, to exclude permissions for all companies, and using another (or several other) to include permissions for a specific company, using security filters.
 
I've created a permission set, where I include all permissions on table 2000000006 (Company), from the System application published by Microsoft.
This is included in a permission set, where I use it as a permission set relation, in this I exclude the permission from my permission set, to remove access to all companies.
In a new permission set, I grant the access to a specific company, by using security filter on table 2000000006. Now this is no longer possible as of versio25.1.25873.27434. It was possible in version 25.0.23364.24925.
 
I have attached some screenshots of the setup. Upon closing the page of the permission set, which grants permission to a specific company, I get this error:
One or more errors occurred while closing the page.

The value "Company: Id={595C72D7-1A7A-EF11-AC24-6045BDE98980}" can't be evaluated into type TableFilter. The value "{595C72D7-1A7A-EF11-AC24-6045BDE98980}" can't be evaluated into type Integer.
One or more errors occurred while closing the page.

The value "Company: Id={595C72D7-1A7A-EF11-AC24-6045BDE98980}" can't be evaluated into type TableFilter. The value "{595C72D7-1A7A-EF11-AC24-6045BDE98980}" can't be evaluated into type Integer.
 
This error only started, when it went from version 25.0 to 25.1. Now it isn't possible to create the Security Filter.
Mine persists as it was made in version 25.0, but doesn't work anymore.
 
The big gain from this, was that it was now possible to have a clean overview of permission sets.
I could have a permission set, to grant finance access for someone, but it would not grant them access to the company.
I could use another permission set to grant access to the company.
When they would use the company selector, they would only be able to see the companies I had assigned to them.
All this to make it easier to handle from the Security Groups in Business Central, to handle it in Microsoft Entra ID as minimalized Security Groups there.
 
I have tried to use a debugger to spot the difference in the code, but I cannot find the root of the issue...
 
I'm unsure whether it is a bug fix from Microsoft, and they intentionally removed this option, or whether it is a bug that they need to fix.
 
Thank you in advance 😊
 
All pictures and error codes are from my CDX environment.
Categories:
  • PR-11120843-0 Profile Picture
    PR-11120843-0 2 on at
    Security Filter in permission set on table 2000000006 doesn't work anymore
    Hi Kaspars,

    Thank you for taking your time, to reply to my question.
     
    I have tried to recreate it, yes 😊
    Unfortunately, the same exact error code show up.
     
    Somehow there should be a coding functionality, to set Disallowed on a record, resulting in any Security Filter to result in an error:
     
    This just doesn't seems like the case, when I look into it, but then again - I'm not 100% certain.
     
    I just don't see what should have changed in the latest version comparing to the previous version.
     
    Hopefully I will get my BC Yammer group access shortly, so I can ask the question to Microsoft 😊
    I'm unsure whether Microsoft monitors this site for potential bugs or not.
  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,926 Super User 2024 Season 2 on at
    Security Filter in permission set on table 2000000006 doesn't work anymore
    Have You tried to manually re-create it? 
    Seems like some field types could be changed, but not sure why they would change GUID to Integer :D 
    Manually recreating them could fill in the needed fields according to the new changes. But I haven't tried this... not using the latest versions yet :)
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans