Bug report #16531

DB manager/browser should not show the schemas/tables the user has no permission on

Added by Giovanni Manghi about 6 years ago. Updated about 4 years ago.

Category:DB Manager
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:24437


When choosing the "add PostGIS layer" dialog the user is presented with ONLY the schemas he/she has permission (USAGE) on.

On the other hand in DB Manager and Broswer the user is also presented with the schemas that he/she cannot use, the tables are also listed in DB Manager (not the browser) but if the user tries to add them gets an error.

For sake of consistency those schemas should be shown to the user.


#1 Updated by Giovanni Manghi about 4 years ago

  • Status changed from Open to Feedback

Please check if this issue is still valid on QGIS 3.4.5 or 3.6.

Also available in: Atom PDF