Home

Extend

Hashnode Pro
Hashnode for Agents

Resources

The foreword
Hashnode gql skill

Buildful - AI coding agent that delivers frontier-level results at a fraction of the cost Bug0 - The AI-native e2e QA regression testing Hackathons Changelog Brand @hashnode on X Hashnode on LinkedIn Support - hello+support@hashnode.com Code of Conduct Terms Privacy Sitemap

Search Hashnode

Search posts, tags, users, and pages

Discussion on "CI/CD for APEX and Oracle Database: Mid-2025 Insights" | Hashnode

Feed/

Discussion

Rafal Grzegorczyk

Oracle APEX & PL/SQL Developer at Pretius Low-Code

Jun 26, 2025

CI/CD for APEX and Oracle Database: Mid-2025 Insights

After presenting "Oracle's SQLcl CI/CD bombshell" at KSCOPE25, I'm excited about where we are in Oracle CI/CD development. The response was fantastic, and it's evident we are at a breakthrough moment. You can view my presentation and live demo videos...

rafal.hashnode.dev4 min read

#sqlcl #projects #apex #orclapex #oracle #oracle-apex #databases #cicd #cicd-complete-proccess #devops

Responses1

Markdown supported · ⌘↵ to post

Michael Abele

oracle apex

Jun 27, 2025

Thanks for sharing!

I am wondering which user is used for the database connection dev_admin? SYS?

Michael Abele

oracle apex

Jun 30, 2025

Rafal Grzegorczyk Thanks for your response! My question is: what user do you use for these connections? A proxy user would work, but then this user needs to have all object priviliges to all schemas included in the SQLcl projects project. And if a new object is created, this has to be granted to get the projects export working... so that's why I'm wondering if you use SYS as user for your "Dev admin" connection?!

Rafal Grzegorczyk

Oracle APEX & PL/SQL Developer at Pretius Low-Code

Jun 30, 2025

Michael Abele dev_admin is an ADMIN user at OCI, so it will always have the required grants. For exports, you should always use a user who has the privileges required for the schemas included in the project. For OCI, it can be ADMIN, for non-premise, it could be a user with a role assigned ( and that role should have everything required). Basically, is up to you.

Michael Abele

oracle apex

Jun 30, 2025

Rafal Grzegorczyk thanks a lot for your detailed explanation!