Forum Stats

  • 3,815,381 Users
  • 2,259,010 Discussions
  • 7,893,063 Comments

Discussions

how to retain the object owner in changesets upon running lb update from a different account?

wes_fdny
wes_fdny Member Posts: 15 Red Ribbon

Stuck on a seemingly simple issue while trying to experiment a CI/CD process.

Setup:

  1. DB Admin creates a system user called "SQLCL_JENKINS" to push change sets to test,stage and prod env.
  2. Developer creates a new user called "FDNY" and builds out the schema.
  3. Developer is ready to move code from Dev to Test.
  4. Developer points SQLCL at Dev FDNY and runs lb genschema. The content of the files have Owner set to each object as FDNY. Code is versioned in github.
  5. DB Admin pulls the github code and launches/logs in to sqlcl/database as SQLCL_JENKINS.
  6. DB Admin runs lb update but the objects generated are created in SQLCL_JENKINS schema and not under the correct FDNY user schema (defined in the changeset xml).

@thatJeffSmith-Oracle or anyone have a solution?

Thanks,

Wes