Uploaded image for project: 'COmanage Framework Migration'
  1. COmanage Framework Migration
  2. CFM-356

Support PostgreSQL schema other than public

    XMLWordPrintable

Details

    • Task
    • Resolution: Done
    • Major
    • PE Milestone 12
    • None

    Description

      CakePHP 4 database configuration respects the PostgreSQL notion of a schema (aka namespace) within a logical database other than the default schema named "public".

      DBAL appears not to respect it with configuration, but it is straightforward to have the DBAL connection object run a command that sets the PostgreSQL search path to the schema that is configured in the CakePHP 4 database configuration.

      Not using the "public" schema by default is considered a good security practice, especially when using a logical database that may have read-only users or other users with less privileges.

      Attachments

        Issue Links

          Activity

            People

              benn.oshrin@at.internet2.edu Benn Oshrin (internet2.edu)
              scott.koranda@at.internet2.edu Scott Koranda (uwm.edu/illinois.edu)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: