Re: privileges oddity

Scott Ribe <scott_ribe@elevated-dev.com> writes:
> 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 

Gonna need more context.  The session-level user seems to have the
right privileges, but maybe something is happening inside a
security-definer function that doesn't have privileges?

            regards, tom lane