Permission denied with Copy command when using network share
With COPY from a named file, the file is read on the server by the user who owns the database cluster (usually a service account) not on the client.  So the server (both machine and account) is what needs to have access to it. If your file is readable on the client, you can use COPY...FROM STDIN in conjunction with the support functions described here.