Hi All,
I created a "Read-only" User in PostgreSQL via a Role with "SELECT" ONLY
privilege on all tables in a schema as shown below:
GRANT SELECT ON ALL TABLES IN SCHEMA [schema_name] TO [role_name]
GRANT [role_name] TO [user_name]
Next, I test this by trying to UPDATE a column in a table (same
Hi,
Thanks for your prompt response. The user was created with the postgres
user (superuser) as below:
CREATE USER WITH PASSWORD ''
authorized
>
> Affiliates of AT&T, and is not for general distribution within or outside
> the respective companies
>
>
>
> *From:* pgadmin-support-ow...@postgresql.org [mailto:
> pgadmin-support-ow...@postgresql.org] *On Behalf Of *Osahon Oduware
> *Sent:* Frid
Tim Hearne*
> CAST / Flex Force Application DBA
> Principal DBA
>
> Centralized Development
> AT&T Services, Inc.
>
> PROPRIETARY INFORMATION
> The Information contained herein is for use only by authorized employees
> of AT&T, and authorized
>
> Affiliates
I would like to know why the privileges/permission is working when tested
with pgAdmin/pgsql, but it is not working with the same user/schema/table
in QGIS.
-- Forwarded message --
From: Osahon Oduware
Date: Fri, Mar 17, 2017 at 4:17 PM
Subject: Re: [pgadmin-support] QGIS Seem To
herein is for use only by authorized employees
> of AT&T, and authorized
>
> Affiliates of AT&T, and is not for general distribution within or outside
> the respective companies
>
>
>
> *From:* Osahon Oduware [mailto:oduwareosa...@gmail.com]
> *Sent:* Friday, March 17,
ke your pgadmin is working as expected so I
> would suggest that you double check your qgis configuration.
>
> Rich
>
>
> On Fri, Mar 17, 2017 at 9:45 AM, Osahon Oduware
> wrote:
>
>> Hi Tim,
>>
>> Ok, thanks for your help.
>>
>> On Fri, Mar 17, 201
ke your pgadmin is working as expected so I
> would suggest that you double check your qgis configuration.
>
> Rich
>
> On Fri, Mar 17, 2017 at 9:45 AM, Osahon Oduware
> wrote:
>
>> Hi Tim,
>>
>> Ok, thanks for your help.
>>
>> On Fri, Mar 17, 2017 a
