AWS AmazonRDS: Document aws_s3 extension upgrade and EXECUTE permission revocation
Summary
Adds an 'Upgrading the aws_s3 extension' section explaining that engine upgrades don't upgrade the extension, that ALTER EXTENSION ... UPDATE is required, and an Important note that upgrading 1.1 to 1.2 recreates the export functions and revokes previously granted EXECUTE permissions, which must be re-granted.
Security assessment
The new section documents privilege behavior for the aws_s3 extension's S3 export functions, warning that EXECUTE grants are dropped on upgrade and must be re-applied. This is authorization/permission management guidance for a data-export feature; it is documentation of behavior, not a fix for a specific vulnerability or incident.
Evidence
+When you upgrade the `aws_s3` extension from version 1.1 to version 1.2, the extension's Amazon S3 export functions are recreated. As a result, any EXECUTE permissions that you previously granted on these functions to other users or roles (for example, by using `GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA aws_s3 TO your_user;`) are revoked. After this upgrade completes, re-grant these permissions to the affected users or roles.
Diff
diff --git a/AmazonRDS/latest/AuroraUserGuide/postgresql-s3-export.md b/AmazonRDS/latest/AuroraUserGuide/postgresql-s3-export.md index d1e8437..43b2522 100644 --- a//AmazonRDS/latest/AuroraUserGuide/postgresql-s3-export.md +++ b//AmazonRDS/latest/AuroraUserGuide/postgresql-s3-export.md @@ -7 +7 @@ -Installing the extensionOverview of exporting to S3Specifying the Amazon S3 file path to export to +Installing the extensionUpgrading the extensionOverview of exporting to S3Specifying the Amazon S3 file path to export to @@ -35,0 +36,2 @@ You can save DB and DB cluster snapshot data to Amazon S3 using the AWS Manageme + * Upgrading the aws_s3 extension + @@ -92,0 +95,8 @@ If the output includes the string `"s3Export"`, then the engine supports Amazon +## Upgrading the aws_s3 extension + +Upgrading your Aurora PostgreSQL DB cluster to a new version doesn't upgrade the `aws_s3` extension at the same time. To upgrade the extension after the engine upgrade completes, use the `ALTER EXTENSION ... UPDATE` command. For the general procedure, see [Upgrading PostgreSQL extensions](./USER_UpgradeDBInstance.Upgrading.ExtensionUpgrades.html). + +###### Important + +When you upgrade the `aws_s3` extension from version 1.1 to version 1.2, the extension's Amazon S3 export functions are recreated. As a result, any EXECUTE permissions that you previously granted on these functions to other users or roles (for example, by using `GRANT EXECUTE ON ALL FUNCTIONS IN SCHEMA aws_s3 TO your_user;`) are revoked. After this upgrade completes, re-grant these permissions to the affected users or roles. +