[Qgis-user] Connect to PostGIS Without Superuser Privileges

[Elijah Meeks]

QGIS comes back with the following error if I try to connect to PostGIS:

PG:dbname='databasename' host='hostname' port='5432' user='username' password='password' is not a valid or recognized data source

(Databasename, hostname, username and password are all correct, I just changed them to generic values for this post)

The connection works fine when the user/role I connect with is a superuser, but errors out above when I remove superuser status.  I've GRANTed ALL access to the db and the tables for the role, but no change.  I noticed a three year old bug report/feature request similar to this, so I'm assuming I haven't got the right permissions set up.  Any suggestions?

Thanks,
Elijah

************
Elijah Meeks
http://dhs.stanford.edu
Digital Humanities Specialist
Academic Computing Services
Stanford University
emeeks at stanford.edu
(650)387-6170