Was this helpful?
Permissions
To use the COPY statement, one of the following must apply:
You own the table.
If you don’t own the table:
The table has SELECT (for COPY INTO) or INSERT (for COPY FROM) privilege granted to PUBLIC (or the specific user running COPY).
You or PUBLIC are granted COPY_INTO (for COPY INTO) or COPY_FROM (for COPY FROM) privileges on the table.
Last modified date: 02/05/2026