AWS redshift: Add GRANT EXECUTE ON PROCEDURE TO DATASHARE syntax and example
Summary
Documents the syntax for granting EXECUTE on a stored procedure to a datashare, and adds an example showing that the procedure signature (name plus argument types) is required to disambiguate overloaded procedures.
Security assessment
Adds authorization reference material for granting EXECUTE on stored procedures to datashares, including the requirement to specify the full signature so the intended overload is granted; this is access-control documentation, not a fix for a specific vulnerability.
Evidence
+ TO DATASHARE _datashare_name_
Diff
diff --git a/redshift/latest/dg/r_GRANT.md b/redshift/latest/dg/r_GRANT.md index 86049c1..404c5b3 100644 --- a//redshift/latest/dg/r_GRANT.md +++ b//redshift/latest/dg/r_GRANT.md @@ -152,0 +153,7 @@ The following is an example of how to grant usage of a datashare to a Lake Forma +The following is the syntax for using GRANT to add a stored procedure to a datashare. + + + GRANT EXECUTE + ON PROCEDURE _procedure_name_ ( [ [ argname ] argtype [, ...] ] ) + TO DATASHARE _datashare_name_ + @@ -511,0 +519,10 @@ Grants the EXECUTE permission on a specific stored procedure. Because stored pro +The procedure name together with its argument list is the procedure signature. A name alone can refer to several overloaded procedures, so GRANT requires the signature. The following example grants 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) ... + + GRANT EXECUTE ON PROCEDURE public.refresh_summary(varchar) TO analyst; + +