- Más nuevo
- Más votos
- Más comentarios
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.
Está publicación está cerrada: la opción de añadir nuevas respuestas, comentarios y votos está deshabilitada.
Contenido relevante
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace 3 años