- Newest
- Most votes
- Most comments
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.
This post is closed: Adding new answers, comments, and votes is disabled.
Relevant content
- Accepted Answerasked 2 years ago
- asked 3 years ago
- asked 5 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated a month ago
- AWS OFFICIALUpdated a year ago