- 최신
- 최다 투표
- 가장 많은 댓글
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.
이 게시물은 마감됨: 새 답변, 댓글 및 투표 추가가 비활성화되었습니다.
관련 콘텐츠
- 질문됨 7년 전