- Le plus récent
- Le plus de votes
- La plupart des commentaires
Our upgrades by snapshot from aurora v2 to v3 are also on hold because of this. It seems the variable is stuck to enabled after the upgrade:
partial_revokes=ON
And I suspect this is (at least one of the causes) why we cannot properly grant and revoke permissions to our users.
On an aurora v3 cluster created from scratch, the variable is correctly disabled, as specified in the parameter group:
partial_revokes=OFF
Update.
Granting with the escape character also does not work:
GRANT SELECT, INSERT, UPDATE, DELETE ON 'testdb\%'.* TO 'testuser'@'%';
I'm the reporter of this issue. Unfortunately, couldn't sign in with my old account anymore thus writing from the new one. Finally this issue seems to be fixed. Tested on both 'restore from snapshot' and 'inplace upgrade'. This question can be closed.
Cette publication est fermée : l'ajout de nouvelles réponses, commentaires et votes est désactivé.
Contenus pertinents
- demandé il y a 2 mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans