Deploying Application in Oracle APEX - Part 39

Summary

This tutorial guides viewers through deploying an Oracle Apex application in two stages: exporting the application to a script file and importing it into a production environment. It demonstrates exporting a sales web application within the same workspace for simplicity, and then importing it, addressing common errors like authorization issues. The video also covers user role assignments and disabling the developer toolbar to prevent unauthorized modifications, ensuring a secure and controlled application deployment process.

Takeaways

• 🔥 The deployment of an Oracle Apex application involves two main steps: exporting components to a script file and importing that file into the production environment.
• 🛠️ The demonstration will show how to export an Oracle Apex application and import it into the same workspace.
• 📁 After clicking the export button, the file will be saved in the download folder of your PC.
• 🔄 Import the exported SQL file into the existing workspace to which you are connected.
• 🚫 You may encounter an error saying you are not authorized to view the application, requiring manual management of user role assignments.
• 👥 Three users need to be created and assigned different roles: administrator, contributor, and reader.
• 📧 Create the first user with your Workspace Email ID and assign the administrator role.
• 🛡️ For the remaining two users, use any name and assign them contributor and reader roles.
• 🔓 Set the application's authorization scheme to 'No Application Authorization Required' to access the application.
• 🚫 The developer toolbar can be suppressed to prevent users from modifying the application, and it can be re-enabled if needed.
• ✅ Successfully deploying the application in the same workspace applies the same procedure to deploy it to another environment.

Q & A

What are the two main steps involved in Oracle Apex application deployment?

The two main steps are exporting the desired components to a script file and importing the script file into the production environment.

Why might one choose to deploy an application in the same workspace for simplicity?

Deploying an application in the same workspace simplifies the process as it helps in understanding the deployment concept without the complexity of different environments, and the technique is still applicable to the production environment.

What happens when you click the export button in Oracle Apex?

Upon clicking the export button, a file is saved in the download folder of your PC.

What is the purpose of importing an SQL file into an existing workspace?

The purpose is to deploy the exported Oracle Apex application into the existing workspace, which allows for further configuration and use.

What error might you encounter when deploying an application, and how is it resolved?

An error stating 'you are not authorized to view this application' may occur. It is resolved by manually managing user roles and assignments, as application users are not exported with the application.

How many users need to be added after deploying the application, and what roles should they have?

Three users need to be added, with one assigned the administrator role, and the other two assigned contributor and reader roles.

Why are application users not exported as part of the application?

Application users are not exported to maintain security and privacy, requiring manual management of user roles and assignments post-deployment.

What is the developer's toolbar used for in Oracle Apex applications?

The developer's toolbar is used to access the application source and make modifications to the application.

How can you prevent users from modifying the application?

You can prevent users from modifying the application by suppressing the developer toolbar, which removes the edit link and hides the toolbar itself.

What happens when you execute the steps to make the application editable again?

The developer's toolbar and the pencil edit link are re-enabled, allowing users to make modifications to the application.

How does the video guide ensure that the deployment process is applicable to different environments?

The video demonstrates the deployment process in the same workspace but clarifies that the same procedure can be applied to deploy the application to another environment.