[Qgis-user] PostGIS tables not inheriting default privileges in QGIS 2.18

[larry price]

Regarding 1 are you and QGIS accessing the database as the same user?  Is
that user the owner of the database or the schema in which tables are being
created? If not you will need to GRANT the appropriate privileges to the
user QGIS is using ON the parent object of the objects you are trying to
create
https://www.postgresql.org/docs/current/static/sql-grant.html



On Tue, Jul 24, 2018 at 7:53 AM Cliff Patterson <cliffpatterson at gmail.com>
wrote:

> Good morning!
>
> I am having two issues with PostGIS integration in QGIS. Wondering if
> anyone can shed some light on the following.
>
> *Issue 1*: Over the past few months I have noticed that all tables
> created in or imported from QGIS 2.18 to my Postgres/PostGIS database do
> not inherit the default privileges for the given schema (typically I use
> the DB Manager for import or creation of new tables). I continually have to
> alter the privileges manually for the newly created tables (in psql or PG
> Admin). However, when I create  a table in psql or PGAdmin, all default
> privileges are applied to the newly created table. I should add that I
> checked the postgres logs and there are no errors when creating or
> importing tables from QGIS. The only issue, of course, is that the default
> privileges are not applied. Any ideas why this is happening?
>
> *Issue 2: *I finally installed QGIS 3.2.0 and realized that rendering
> PostGIS layers is VERY slow. All layers that load in seconds in 2.18 take
> at least 10x longer in 3.2  A little googling revealed that this is a known
> issue with QGIS 3.2.0, but no clear resolution. Is there currently a fix
> for this issue for QGIS 3? Alternatively, is there a way to optimize
> PostGIS performance in QGIS?
>
> Big Thanks!
> Cliff
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20180724/032fa2a0/attachment.html>