Scott Ribe <scott_ribe(at)elevated-dev(dot)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: permission denied 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