Doctrine DBAL
  1. Doctrine DBAL
  2. DBAL-930

[GH-626] Update PostgreSqlPlatform.php

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Incomplete
    • Affects Version/s: 2.4.3
    • Fix Version/s: None
    • Component/s: Schema Managers
    • Security Level: All

      Description

      This issue is created automatically through a Github pull request on behalf of x42p:

      Url: https://github.com/doctrine/dbal/pull/626

      Message:

      If the database have different schemes, with objects, that the actual logged in user has no rights, the existing statements will collect all objects (sequences and tables) and try to read them in later steps. This will throws exceptions. The reason for that is the fact, that both procedures getListSequencesList() and getListTablesSQL() will receive all known database objects from postgres catalogs. But the actual logged-in user, maby has no read permissions to object inside other scheme-owner. The additional parts inside both sql-statements will reduce the result to only objects that the user are able to see.

        Issue Links

          Activity

          Doctrine Bot created issue -
          Steve Müller made changes -
          Field Original Value New Value
          Status Open [ 1 ] Resolved [ 5 ]
          Assignee Benjamin Eberlei [ beberlei ] Steve Müller [ deeky666 ]
          Resolution Incomplete [ 4 ]
          Steve Müller made changes -
          Component/s Schema Managers [ 10057 ]
          Steve Müller made changes -
          Issue Type Bug [ 1 ] Improvement [ 4 ]
          Steve Müller made changes -
          Priority Major [ 3 ] Minor [ 4 ]
          Steve Müller made changes -
          Link This issue relates to DBAL-1021 [ DBAL-1021 ]
          Marco Pivetta made changes -
          Issue Type Improvement [ 4 ] Bug [ 1 ]
          Marco Pivetta made changes -
          Priority Minor [ 4 ] Major [ 3 ]
          Marco Pivetta made changes -
          Affects Version/s 2.4.3 [ 10622 ]
          Marco Pivetta made changes -
          Labels ddl postgresql schema

            People

            • Assignee:
              Steve Müller
              Reporter:
              Doctrine Bot
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: