Skip to content
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.

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

Identify and fix why the GEAR2 system database account can only be used when deploying app #558

Open
hatfieldjm4 opened this issue Dec 18, 2024 · 1 comment
Assignees
Labels
database A task/issue involving work on the database DEV Relates to work in the development environment help wanted Extra attention is needed PROD Relates to work in the production environment

Comments

@hatfieldjm4
Copy link
Collaborator

It is hard coded somewhere in the database, possibly on a trigger related to the tech catalog data or on the obj_technology object. I believe the database account name is hard coded into this trigger which is preventing other database accounts to be used, if needed (for example, using your personal database account to deploy locally).

@hatfieldjm4 hatfieldjm4 added help wanted Extra attention is needed database A task/issue involving work on the database DEV Relates to work in the development environment PROD Relates to work in the production environment labels Dec 18, 2024
@hatfieldjm4 hatfieldjm4 moved this from Backlog to To do in Deploy GEAR 3.0 Dec 18, 2024
@hatfieldjm4
Copy link
Collaborator Author

hatfieldjm4 commented Dec 18, 2024

The system account is hard coded into triggers on the following objects (that I could find so far). These triggers exist to create insert/update logs, but there may be more uses than simply logging that I'm unaware of.

  • obj_technology
  • zk_technology_poc
  • obj_cuicategory
  • obj_datacenters
  • obj_contracts
  • tp_SoftwareRelease
  • tp_SoftwareVersion
  • tp_SoftwareProduct
  • tp_SoftwareLifecycle
  • tp_Manufacturer

@hatfieldjm4 hatfieldjm4 moved this from To do to Backlog in Deploy GEAR 3.0 Jan 29, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
database A task/issue involving work on the database DEV Relates to work in the development environment help wanted Extra attention is needed PROD Relates to work in the production environment
Projects
Status: Backlog
Development

No branches or pull requests

2 participants