Uploaded image for project: 'Red Hat Advanced Cluster Management'
  1. Red Hat Advanced Cluster Management
  2. ACM-16818

As a global user, I can be able to execute SQL to create DB and grant permission so that i can use the postgres

XMLWordPrintable

    • GH Train-24
    • Important
    • None

      Value Statement

      The feature is required by IoP. refer to https://docs.google.com/document/d/1ZCbuTTZbRdRKomG_l78rxHiuDOJCq_1RPP_8MUSIv_k/edit?tab=t.0#heading=h.y4jydmv9gee

      Definition of Done for Engineering Story Owner (Checklist)

      • Support configuring the annotation to create the database. 
      • global-hub.open-cluster-management.io/postgres-user-<user3>: ["db2"] 
        global-hub.open-cluster-management.io/postgres-user-<user4>: ["db1", "db3"]   
        1. create the database
        2. generate the password
        3. give all permissions for the user to access this db
            * generate a secret to contain username/password/database certs/databases location. refer to https://gitlab.cee.redhat.com/insights-platform/consolebox-operator/-/merge_requests/17#4-create-a-database-secret 
      • Need to check the dashboard to ensure there is no error.
      • Need document how to use this feature.
      • Add integration test

      Development Complete

      • The code is complete.
      • Functionality is working.
      • Any required downstream Docker file changes are made.

      Tests Automated

      • [ ] Unit/function tests have been automated and incorporated into the
        build.
      • [ ] 100% automated unit/function test coverage for new or changed APIs.

      Secure Design

      • [ ] Security has been assessed and incorporated into your threat model.

      Multidisciplinary Teams Readiness

      • [ ] Create an informative documentation issue using the Customer

      Portal Doc template that you can access from [The Playbook](

      https://docs.google.com/document/d/1YTqpZRH54Bnn4WJ2nZmjaCoiRtqmrc2w6DdQxe_yLZ8/edit#heading=h.9fvyr2rdriby),

      and ensure doc acceptance criteria is met.

      • Call out this sentence as it's own action:
      • [ ] Link the development issue to the doc issue.

      Support Readiness

      • [ ] The must-gather script has been updated.

              rh-ee-myan Meng Yan
              clyang82 Chunlin Yang
              Hui Chen Hui Chen
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated: