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:56:06 +0000
Message-ID: <gh-aws-aws-advanced-jdbc-wrapper-2244-rc4592142722@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:887)
The MySQL admin block grants only DML on the metadata tables. The paragraph below says the admin also creates the routines and triggers (steps 3 and 7) and runs re-encryption, but the block doesn't show those grants.
```suggestion
GRANT SELECT, INSERT, UPDATE, DELETE ON encrypt.key_storage TO 'app_admin'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON encrypt.encryption_metadata TO 'app_admin'@'%';
-- Routines and triggers (steps 3 and 7) and re-encryption, in the database that holds your tables
GRANT CREATE ROUTINE, ALTER ROUTINE, EXECUTE ON app_db.* TO 'app_admin'@'%';
GRANT SELECT, UPDATE, TRIGGER ON app_db.users TO 'app_admin'@'%';
```