What is the relationship between workspace and database users in Oracle Express?

Question

I created a workspace with APEX, but now the password is not valid.

Then I entered the workspace and changed my password. However, the other password for logging in does not change.

I am very confused by all these terms in oracle.

I have database username , workspace username , database password , workspace password . There is also a user manager in the workspace, and these users are different from the other two mentioned. Some of the users can be seen in the all_users table, some cannot.

What is the relationship between all these types of users and where is this information stored? I read some Oracle materials, but no one mentioned these basic terms.

Answer 1

This is confusing because it uses two different (but free) technologies:

1) Oracle Database Server has the concept of "users" of the database, which you can see by dba_users and all_users are the owners of the database objects, and each automatically receives the same name schema. Each of these database users has a password controlled by the database. In the old days, we used to provide a separate user database for each end user; currently we are not usually. These users are stored in the database data dictionary and are only managed using database commands such as CREATE USER and ALTER USER .

2) Oracle Application Express has the concept of "workspaces", each of which can have one or more "users". These users can be regular end users, developers, or Apex administrators. Each of these users has a password controlled by Apex. They are not related to schemas in the database. These users are stored in the Apex data dictionary and managed using the Apex admin interface or through the Apex API calls (in PL / SQL).

Each apex workspace is associated with a database schema (= database user) that contains the database objects (e.g. tables, views, etc.) needed by the workspace. (Note: a workspace can be associated with more than one database schema).

To make things more confusing, in the default version of Apex pre-installed on OracleXE (the free version of the database), the Apex SYSTEM user has the same password as the SYSTEM database user.

By default, Apex applications use the Apex authentication scheme, which authenticates users against the Apex data dictionary (according to (2) above). However, you can use alternative authentication schemes that authenticate users against other repositories (such as LDAP, SSO, or custom schemes).