AWS AmazonRDS: Document aws_s3 extension upgrade and EXECUTE permission revocation
Summary
Adds an 'Upgrading the aws_s3 extension' section explaining that upgrading the extension from 1.1 to 1.2 recreates its Amazon S3 export functions, revoking previously granted EXECUTE permissions, and instructs users to re-grant them.
Security assessment
The added note documents a privilege/authorization side effect of an extension upgrade (EXECUTE grants on aws_s3 functions being dropped), which is security-relevant permission guidance, though it does not describe a specific vulnerability or CVE.
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/UserGuide/postgresql-s3-export.md b/AmazonRDS/latest/UserGuide/postgresql-s3-export.md index eefd818..69fddbb 100644 --- a//AmazonRDS/latest/UserGuide/postgresql-s3-export.md +++ b//AmazonRDS/latest/UserGuide/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 @@ -33,0 +34,2 @@ You can save DB snapshot data to Amazon S3 using the AWS Management Console, AWS + * Upgrading the aws_s3 extension + @@ -90,0 +93,8 @@ If the output includes the string `"s3Export"`, then the engine supports Amazon +## Upgrading the aws_s3 extension + +Upgrading your RDS for PostgreSQL DB instance 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.PostgreSQL.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. +