Fernando Schapachnik <fernando@mecon.gov.ar> writes:
> ERROR: usr: permission denied
AFAIR, all our "permission denied" messages cite the object in question,
not the referencing user. So this is complaining about access rights to
the "usr" schema. You have not shown us enough information to guess why
this query would need to look into the "usr" schema --- but presumably
someone needs the USAGE right on "usr", and hasn't got it.
regards, tom lane