- 新しい順
- 投票が多い順
- コメントが多い順
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.
この投稿はクローズされています。新しい回答、コメント、投票の追加はできません。
関連するコンテンツ
- 質問済み 6年前
- AWS公式更新しました 1年前