Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Why is Postgres user XX via command „Add PostGIS Layers“ in QGIS enabled upload only View tables which owns? Or how to achieve it to the user XX via PostGIS can load View table which owns the user YY?

Main table from the database with different users are assigned by rolls, however the View tables we could not find that there is a possibility of assigning rolls.

Any idea how solve this problem?

share|improve this question
you need to be postgres root (superuser) to view all tables. Is a security feature of postgres. Use the GRANT feature - – Mapperz Apr 17 '13 at 13:32
up vote 2 down vote accepted

user XX must give privilege to user YY on that view table
in PgAdmin SQL editor user XX should write:


and of course user YY must be member of ROLE XYZ

share|improve this answer

The QGIS table browser has a well-hidden option that you need to toggle to tell it what column to use as a unique key before it will let you display a view.

How to make a spatial view in PostGIS and add it as a layer in QGIS?

Which means, also, your view has to include a unique column to use as a key.

share|improve this answer
brunci has a problem that he can not see any of View tabels that the owner of the table can see (There is no problem with unique column) – hapa Apr 18 '13 at 6:42

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.