AWS redshift documentation change
Summary
Expanded permission requirements documentation for COPY JOB operations
Security assessment
Adds detailed documentation about required permissions (including superuser status and scoped permissions) for COPY JOB operations, which relates to access control security features.
Diff
diff --git a/redshift/latest/dg/r_COPY-JOB.md b/redshift/latest/dg/r_COPY-JOB.md index 2f3d5ee8f..321922a20 100644 --- a//redshift/latest/dg/r_COPY-JOB.md +++ b//redshift/latest/dg/r_COPY-JOB.md @@ -21 +21,14 @@ For information about the COPY command, including usage, parameters, and permiss -To run the COPY command of a COPY JOB, you must have INSERT privilege of the table being loaded. +To use the COPY JOB command, you must have one of the following permissions in addition to all of the required permissions to use COPY: + + * Superuser + + * All of the following: + + * The relevant CREATE, ALTER, or DROP scoped permission for COPY JOBS in the database you want to COPY to. + + * USAGE permission for the schema you want to COPY to, or USAGE scoped permission for schemas in the database you want to COPY to. + + * INSERT permission for the table you want to COPY to, or INSERT scoped permission for tables in the schema or database you want to COPY to. + + +