From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: privileges oddity |
Date: | 2020-08-06 18:22:31 |
Message-ID: | 69106152-81a7-34c0-d170-4462b0f1e2c7@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 8/6/20 11:11 AM, Scott Ribe wrote:
> when user akanzler tries to run query "SELECT * FROM zoewang.sometable...", it triggers this error:
>
> 2020-08-06 17:27:27.664 UTC [15914]: [3] user=akanzler,db=risk_oltp_prod,app=[unknown],client=10.8.170.24: ERROR: permission denied for schema zoewang at character 15
>
> --- YET ---
>
> risk_oltp_prod=# \dn+ zoewang
> List of schemas
> Name | Owner | Access privileges | Description
> ---------+----------+------------------------+-------------
> zoewang | srv_risk | srv_risk=UC/srv_risk +|
> | | akanzler=UC/srv_risk +|
> | | srv_risk_ro=U/srv_risk |
> (1 row)
>
> HUH? (And the user also has all privs on all the tables in the schema...)
Schema for the table?
>
> --
> Scott Ribe
> scott_ribe(at)elevated-dev(dot)com
> https://www.linkedin.com/in/scottribe/
>
>
>
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2020-08-06 18:35:26 | Re: privileges oddity |
Previous Message | Tom Lane | 2020-08-06 18:22:00 | Re: privileges oddity |