Use Credentials to connect to REST Enabled SQL or other external REST services. Oracle Application Express securely stores and encrypts these credentials for use by Application Express components. Credentials cannot be retrieved back in clear text. Credentials are stored at the workspace-level and therefore are visible in all applications.
Exporting and Importing Credentials
When you export an application, used credentials are added to the export file. When you import the application into another workspace, Application Express checks whether the target workspace already contains credentials with the same static ID. If a credential already exists, the application uses it. Otherwise the credential from the import file is created in the target workspace.
On the Application home page, click Shared Components in the center of the page.
Under Security, select Web Credentials.
On the Web Credentials page, select the credential name.
To delete the credentials, click Delete. Otherwise, edit the appropriate attributes.
A credential cannot be deleted when it is being referenced somewhere in the workspace.
To edit the attributes:
Name - Enter a descriptive name.
Authentication Type - Select a type:
OAuth2 Client Credentials
Client ID or User Name: For Basic Authentication, enter the user name. For OAuth2, enter the client ID. This information will not be encrypted.
Client Secret or Password - Enter the password or OAuth2 Client Secret.
This information is stored encrypted and cannot be retrieved in clear text.
Verify Client Secret or Password - Enter the password or client secret again to verify your input. When the two values are not identical, an error message displays.
Prompt on Install - Choose whether prompts for this credential display when the application is imported on another Application Express instance. Since credentials are not part of an application export file, Application Express always generates prompts after install, when the client ID or username is not empty.
Comments - Enter any comments or notes. These comments only display within App Builder and never display when running the application.