AWS redshift: Document REVOKE EXECUTE on procedures and datashares
Summary
Adds syntax for revoking EXECUTE on a stored procedure from a datashare, and clarifies that REVOKE requires the full procedure signature (name plus argument list) to disambiguate overloaded procedures, with an example.
Security assessment
The change documents privilege revocation (REVOKE EXECUTE) semantics, including that a bare procedure name can match multiple overloaded procedures so the signature is required. This is authorization/privilege-management documentation that helps administrators revoke the intended privilege rather than an ambiguous one, but it does not reference a specific vulnerability or incident.
Evidence
REVOKE EXECUTE ON PROCEDURE public.refresh_summary(varchar) FROM analyst;
Diff
diff --git a/redshift/latest/dg/r_REVOKE.md b/redshift/latest/dg/r_REVOKE.md index f8d9424..fb72f47 100644 --- a//redshift/latest/dg/r_REVOKE.md +++ b//redshift/latest/dg/r_REVOKE.md @@ -125,0 +126,7 @@ The following is an example of revoking usage of a datashare from a Lake Formati +The following is the syntax for using REVOKE to remove a stored procedure from a datashare. + + + REVOKE EXECUTE + ON PROCEDURE _procedure_name_ ( [ [ argname ] argtype [, ...] ] ) + FROM DATASHARE _datashare_name_ + @@ -457 +464,11 @@ Revokes the EXECUTE permission on a specific stored procedure. Because stored pr -EXECUTE ON ALL PROCEDURES IN SCHEMA _procedure_name_ +The procedure name together with its argument list is the procedure signature. A name alone can refer to several overloaded procedures, so REVOKE requires the signature. The following example revokes EXECUTE on one of two overloaded procedures. + + + -- Two overloads of the same name + CREATE PROCEDURE public.refresh_summary(p_region varchar) ... + CREATE PROCEDURE public.refresh_summary(p_region varchar, p_day date) ... + + REVOKE EXECUTE ON PROCEDURE public.refresh_summary(varchar) FROM analyst; + + +EXECUTE ON ALL PROCEDURES IN SCHEMA _schema_name_