Logging into Oracle Application Express as a Database User
As part of the database security, I have separate access for each user (same as in Oracle). Now I want to add these users as Oracle Application Express (Apex) users. When I try to create new users, APEX does not give me the option to use database users as APEX users.
Essentially I have three users - STUDENT, TEACHER AND UNIVERSITY. UNIVERSITY has two tables - STUDENT_INFO and TEACHER_INFO STUDENT DB User cannot view information about TEACHER_INFO and similarly to TEACHER DB. User cannot view information about STUDENT_INFO. I wanted to show this information via APEX, not sqlplus. so I need the STUDENT user to go into APEX and try to access UNIVERSITY.TEACHER_INFO and UNIVERSITY.STUDENT_INFO to show the difference. How can I add these users as APEX users if I already have admin privileges for APEX.
source to share
First, APEX users are not database users. Apex users are pseudo-users who have schemas using the Apex admin area.
I am assuming you are not trying to create an authentication scheme in Apex, a completely different subject.
If you create a workspace in Apex that has access to all 3 diagrams (this is not a problem). You create a single administrator (again a pseudo-vertex user) with full control.
This administrator can create other users in the adminstration-> users interface. There he can provide access to all, none, not a subset of the schemas. Define them as app users, developers (who you want them to be able to log in to the top) or administrators (don't want to)
I took this from the internet. Pay attention to the field of available schemes. This is where you define it.
source to share
As I understand it, you want to access tables in SQL Workshop
? You first need to know that oracle database users and oracle APA users are different things. After creating APEX users, you need to go to Administration
and find a menu there for managing workspaces. I no longer have APEX, except for an account at apex.oracle.com (administration functions are limited there) and I do not remember the exact names of the menu. You must grant these users access to the workspace (if necessary), and then determine which DBMS the DBMS for that database can use (this is also in the workspace management section). It can use one SCHEMA as default, and other SCHEMAs can be added later. After adding SHEMA UNIVERSITY and STUDENT, you will have access to your objects in SQL Workshop
.
Link to documentation: https://docs.oracle.com/cd/B28359_01/appdev.111/b32258/adm_wrkspc.htm#BABDEBHA
source to share