Uploaded image for project: 'Doctrine DBAL'
  1. Doctrine DBAL
  2. DBAL-930

[GH-626] Update PostgreSqlPlatform.php

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: 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

          doctrinebot Doctrine Bot created issue -
          Hide
          doctrinebot Doctrine Bot added a comment -

          A related Github Pull-Request [GH-626] was closed:
          https://github.com/doctrine/dbal/pull/626

          Show
          doctrinebot Doctrine Bot added a comment - A related Github Pull-Request [GH-626] was closed: https://github.com/doctrine/dbal/pull/626
          deeky666 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 ]
          deeky666 Steve Müller made changes -
          Component/s Schema Managers [ 10057 ]
          deeky666 Steve Müller made changes -
          Issue Type Bug [ 1 ] Improvement [ 4 ]
          deeky666 Steve Müller made changes -
          Priority Major [ 3 ] Minor [ 4 ]
          deeky666 Steve Müller made changes -
          Link This issue relates to DBAL-1021 [ DBAL-1021 ]
          ocramius Marco Pivetta made changes -
          Issue Type Improvement [ 4 ] Bug [ 1 ]
          ocramius Marco Pivetta made changes -
          Priority Minor [ 4 ] Major [ 3 ]
          ocramius Marco Pivetta made changes -
          Affects Version/s 2.4.3 [ 10622 ]
          ocramius Marco Pivetta made changes -
          Labels ddl postgresql schema

          This list may be incomplete, as errors occurred whilst retrieving source from linked applications:

          • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={expand=changesets[0:20].revisions[0:29],reviews, query=DBAL-930}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

            People

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

              Dates

              • Created:
                Updated:
                Resolved: