Hello dears, What is the best way to create a functionality in Oracle Apex that allows only roles with permission to perform a certain CRUD operation (for example, one role can delete, but another cannot, etc.)?. I have created the tables (roles per user, pages per roles, etc.). The maintenances (500 or more) would be created based on a page with a region of type "Interactive Report" and another with a "form".
I am aware that I can in a region of type "Interactive Grid" make use of the "Allowed Row Operations Column" property to achieve this conditionally and that using "Dynamic Actions" I can programmatically disable the "create" button, etc. I have also read that I can edit the region query and manage a link type column and condition it.
My interest is that it be as simple or automatic as possible for each developer. For example, actually in that Oracle Forms application we only call a routine when forms load (one line of code) that disables, based on the role's privileges, that CRUD operation that is not allowed. That was added in the model/base form and every developer uses it when creating a new form.
Thanks for your help.