Scott Ribe <scott_ribe@xxxxxxxxxxxxxxxx> 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
