Re: privileges oddity

Greetings,

* Scott Ribe (scott_ribe(at)elevated-dev(dot)com) 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...)

Are you 110% sure that you're actually connecting to the same instance
in both cases (I'd say database too, but hopefully psql isn't lying to
you about that on your prompt, but maybe double-check anyway...).

Have you re-tried from the app (maybe someone fixed it in the
meantime)?

Thanks,

Stephen