-1

I have a workspace named DEV that contains two schemas: ADMIN and DEV_1.

Inside this workspace, I also have two developer accounts:

  • DEV_1 (developer)
  • DEV_2 (developer)

And I have two applications:

  • App 1 → uses schema ADMIN

  • App 2 → uses schema DEV_1

My requirement is:

  • DEV_1 should only be able to access and edit App 1

  • DEV_2 should only be able to access and edit App 2

How can I configure Oracle APEX so each developer only has access to the specific application(s) I assign to them, instead of seeing or editing all applications in the workspace?

I checked the “Edit User” page, but I only see global developer role settings, not application-level permissions.

What is the correct way to set this up?

Improve this question
4
  • 1
    This is not possible. You can only apply this sort of limitation at runtime - disable users from certain applications. Commented Nov 18 at 5:39
  • Hi @Scott Thanks for your reply. Do you have any ideas on this? Commented Nov 18 at 7:02
  • Is there a reason that you need both applications in the same workspace? The normal solution here would be to create one workspace for APP_1 and one workspace for APP_2 and then give developers accounts in whichever workspace(s) they need Commented Nov 18 at 17:47
  • Hi Justin Cave The main reason here is that we want to use the workspace as a working environment: dev, uat and prod In the dev workspace, many schemas will be created for many departments to access and develop on it. Therefore, we want to limit the access rights of the applications in that workspace to ensure that the developer of this department cannot edit the application of another department Commented Nov 19 at 9:11
Load 6 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.