Uploaded image for project: 'Red Hat 3scale API Management'
  1. Red Hat 3scale API Management
  2. THREESCALE-9735

Specify what type of privileges should a DB_USER have

    XMLWordPrintable

Details

    • 3
    • False
    • None
    • False
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • Not Started
    • API CCS Sprint 44 (3Scale) 2

    Description

      Current state:
      Our documentation states that the system-database secret should have the following URL: 

      URL: "mysql2://\{DB_USER}:\{DB_PASSWORD}@\{DB_HOST}:\{DB_PORT}/\{DB_NAME}"

      The same happens for zync database secret:

        DATABASE_URL: postgresql://<zync-db-user>:<zync-db-password>@<zync-db-host>:<zync-db-port>/zync_production

      However there is no indication of what type of privileges the db user should have.

      Desired state:
      Specify what type of privileges the db user should have in both system-database and zync-database chapters.

      Attachments

        Issue Links

          relates to

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) THREESCALE-10857 Database user permissions required for 3scale installation/upgrades vs. those required for daily operations

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Defining

          Enhancement - An enhancement to or refactoring of existing functionality that is not configurable by an end user (typically a change made by an internal team that affects users) THREESCALE-10896 Database user permissions required for PostgreSQL

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Defining
          links to

          GitHub 3scale/3scale-operator#833: system-database secret documentation is unclear

          Activity

            People

              Unassigned Unassigned
              rhn-support-avilatus Anna Vila Tusell
              Darren Fennessy Darren Fennessy
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated: