Re: privileges oddity

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:
permissiondenied 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@elevated-dev.com
> https://www.linkedin.com/in/scottribe/
> 
> 
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com