Admin vs. App User Installation: Choosing the Right Path for Secure, Efficient Deployments
Choosing the right deployment approach is essential when deploying changes to Oracle Database and APEX applications. One key decision involves selecting between an admin (privileged) user installation and an app (object owner) user installation. Each...
Steve Max
Hi Dan, thank you for this insightful article. I am currently on Oracle 19c, APEX 24.2, and SQLcl 25.3 and wants to start my next project with SQLcl Project. After careful consideration, I have decided that using the admin user is the way to go since my new project will have multiple schemas. One question I have is what privileges should the admin user have? I expect that the admin user will contain the changelog tables and have privileges to create and alter objects in the application schemas.