From: aaron-congo (@aaron-congo) <noreply+aaron-congo@github.com>
To: aws/aws-advanced-jdbc-wrapper <noreply+aws-aws-advanced-jdbc-wrapper@github.com>
Subject: Re: [aws/aws-advanced-jdbc-wrapper] PR #2244: docs: kms least privilege
Date: Mon, 16 Nov 2026 21:53:04 +0000
Message-ID: <gh-aws-aws-advanced-jdbc-wrapper-2244-rc4592103353@github.com> (raw)
In-Reply-To: <gh-aws-aws-advanced-jdbc-wrapper-2244@github.com>
References: <gh-aws-aws-advanced-jdbc-wrapper-2244@github.com>
(on docs/using-the-jdbc-driver/using-plugins/UsingTheKmsEncryptionPlugin.md:858)
The admin column doesn't include `SELECT` and `UPDATE` on the application tables, but `KeyManagementUtility` needs both to re-encrypt.
```suggestion
| Database | `SELECT` on `key_storage` and `encryption_metadata`; normal DML on the application tables | Write access to `key_storage` and `encryption_metadata`; `SELECT` and `UPDATE` on the encrypted columns' tables (re-encryption reads and rewrites every row); DDL and trigger creation on the application tables |
```