Is there any way to handle Object Level Security dynamically like how Row Level Security can be handled via DAX statements?
Currently in our tabular models we do row level security by doing a DAX lookup against a table that lists the username and the RLS filter.
We want to utilize OLS by dynamically checking a user table that would list what objects or roles they would be allowed to see.
I do not see anyway to assign OLS dynamically as the users must be manually assigned to the roles they are in.
Is there no way to assign users to roles dynamically?