Permissions
To copy from a table into a file or from a file to a table, one of the following must apply:
• You own the table.
• The table has select (for copy into) or insert (for copy from) permission granted to public.
• The current session is running with a user, role, or group identifier that has been granted select (copy into) or insert (copy from) privilege on the table.