问题原文
原帖链接 · Lester · CC BY-SA 4.0
I have been trying to install Keycloak but instead of the usual 'GRANT ALL PRIVILEGES' command to grant access to the database to the MySQL database, I need the exact minimum privileges to be granted. I have been looking at Keycloak documentation for this but I did not find any.
Thanks.
已采纳解答
原帖链接 · Lester · CC BY-SA 4.0
For those wondering, the following privileges work:
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, REFERENCES, INDEX, DROP ON `<database>`.* TO `<user>`@`<host>`;
摘自公开归档,保留原文语言,版式经整理,外部媒体与邮箱地址已移除。
