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

[Cliff Patterson]

It's funny how writing a question is usually the first step to answering
it. Larry, you win! That was exactly the problem. I was logged in with my
account which is not the owner of the schema. I realized that while digging
a little deeper.

So this begs the question, how does one allow users to create tables that
will inherit the default permissions without giving them explicit ownership
of the schema? For instance, in my database I have a staff group that has
read-only access to the database and other more specific groups that have
more privileges, depending on the schema.

Item 2? Anyone? Anyone? Bueller...? Bueller...? I am installing 3.2.1 now
-- fingers crossed the problem is fixed.

Thanks for the help!

Cliff

On Tue, Jul 24, 2018 at 12:20 PM, larry price <laprice at gmail.com> wrote:

> 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/4422e9cc/attachment.html>