Implement dynamic roles with cakedc users in cakephp 4.2

Can I have a table with the roles of cakedc users, add new ones, set the permissions for each and even set what fields of a table they can see? Or maybe is there another plugin that allows to do this?

See the discussion here:

Thank you, it says what class I should extend to retrieve permissions from a database, but it doesn’t say what is the structure of the tables in the database, can you tell me how to do that please?

I am not going to explain to you the whole process but basically you need to create your own Provider which extends the

In that one you can then load rules from the database (in whatever structure you want to) and return them in the predefined array structure (like the permissions.php) in the getPermissions() method of your class.