Hello everyone,
I have an Oracle APEX-based system that I’m currently enhancing with the help of two developers. However, I’m facing a challenge with permissions.
In Oracle APEX Workspaces, I can assign a developer to either:
- The application (APEX builder), or
- The database (SQL Workshop),
but not both at the same time in a controlled manner.
What I need is the following:
- Grant a developer access to both the APEX application and the underlying database (tables, views, packages, etc.).
- Restrict the ability to export the APEX application or perform full database exports (to avoid system leakage or unauthorized copying).
Unfortunately, the current roles (Developer, SQL Developer, etc.) don’t allow this level of granularity. Is there a recommended approach, workaround, or best practice to achieve this kind of controlled development access?
Any help or advice would be greatly appreciated.
Thank you!