New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Run local sync script as proxy user #19

Open

2 tasks

franTarkenton opened this issue Oct 3, 2024 · 0 comments

Labels

Milestone

Implment local Ep...

Member

franTarkenton commented Oct 3, 2024

When the ephemeral oracle database and the ephemeral postgres databases have been created to support development, they should both use the same user/grants/roles as the script does when running on prem. Unfortunately the code to create those grants exists in a private repo here:
https://github.com/bcgov-nr/nr-fsa-scripts/blob/main/scripts/SPAR/ddl/create_proxy_spar_roles.sql

Need to either make the grants private, or figure out a secure way to get the code and apply it when the docker-compose spins up.

user / roles / grants that apply on prem are applied to the ephemeral database
sync code runs as the same proxy user as it does when run on prem

franTarkenton moved this to Sprint in DevOps (NR)

franTarkenton added this to DevOps (NR)

franTarkenton added this to the Implment local Ephemeral Oracle Database milestone

franTarkenton added the enhancement label

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment