Does removal of access to a user affect current connections?

Question

If I (or my DBAs) revoke a user's access to a MySQL database, what will happen to the existing connections?

In particular, if an app is using a persistent connection to talk to the database, will it get affected immediately when the access is revoked?

Possible duplicate of [When is Flush Privileges in MySQL really needed?](https://stackoverflow.com/questions/36463966/when-is-flush-privileges-in-mysql-really-needed) — Dalton Cézane, Jun 25 '19 at 18:27
This is not exactly a dupe. I am coming from a world unaware of `FLUSH PRIVILEGES` aspect of MySQL. — codeforester, Jun 25 '19 at 18:59

score 2 · Accepted Answer · edited Jun 25 '19 at 18:58

According to manual here:

A revoked role immediately affects any user account from which it was revoked, such that within any current session for the account, its privileges are adjusted for the next statement executed.

Revoking a role revokes the role itself, not the privileges that it represents. If an account is granted a role that includes a given privilege, and is also granted the privilege explicitly or another role that includes the privilege, the account still is granted that privilege after the first role is revoked. For example, if an account is granted two roles that each include SELECT, the account still can select after either role is revoked.

Does removal of access to a user affect current connections?

1 Answers1