Skip to Main Content
  • Questions

  • Restrict Application access to developers in same workspace

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Manvi.

Asked: September 25, 2019 - 8:17 am UTC

Last updated: November 01, 2019 - 1:10 am UTC

Version: 19.1

Viewed 1000+ times

You Asked

How to show a user only certain amount of applications in app builder(i.e user should not be able to see all applications in app builder)?

In a Oracle Apex workspace, I need to create a new user(admin role) such that the new user can only see selected applications in its app builder. All the applications in the original workspace should not be visible.

and Connor said...

I got this from David Peake, one of the APEX product managers

Assuming you are asking about access to App Builder and not end user access --
There is no way to limit access to apps within a workspace. If you have developer or Workspace Admin rights on the workspace then you can access all of the apps within that workspace.
An alternative would be to set up 3 workspaces:
Workspace 1 = Apps 121, 122, 123; Developer = User A
Workspace 2 = Apps 124, 125; Developer = User B
Workspace 3 = Apps 126, 127; Developers = User A and User B
Each Workspace can be associated with the same schemas or be associated with different schemas as required.
Each workspace can also be associated with multiple schemas = many to many associations between workspaces and schemas.
For example, Workspace 1 associated with Schema X and Schema Z, Workspace 2 associated with Schema Y and Schema Z, and Workspace 3 associated with Schema Z

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, October 31, 2019 - 4:18 am UTC

Thank you for the confirmation.

Manvi, October 31, 2019 - 4:19 am UTC

Thank you for the confirmation that we cant restrict applications like this in a workspace
Connor McDonald
November 01, 2019 - 1:10 am UTC

glad we could "help".

You can always add ideas for the apex team to consider at their forum

https://community.oracle.com/community/groundbreakers/database/developer-tools/application_express
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.