AWS – Amazon Redshift now supports fine-grained access control on COPY and UNLOAD commands
You can now grant the privilege to run COPY and UNLOAD commands to specific users and groups in your Amazon Redshift cluster to create more fine-grained access control policy.
Read More for the details.