MySQL 5.6 question about revoking an active session

Robert Silver
Robert Silver used Ask the Experts™
on
So far I experimented on a MySQL 5.6 server
I tried
grant all on *.* to 'myuser'@'%' with grant option;

all worked fine. I then tried  from myuser's  account to kill another session one of the su
per only privileges and it let me so obviously when you grant all on *.* it also grants super privileges but I assume that would be only if *.* (Global) was used

Now I then tried:
revoke super on *.* from  'myuser'@'%' ;

I then for safe measure:
flush privileges;
go back to my live session and try to kill another session and I can still kill others session
so my question here would be why don't the revokes take immediately
I could kill the active user but that seems a schlocky solution:

Any way to do this revoke on active sessions???
I did find the super privilege was revoked upon reconnect but what about live connections??
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Rick HobbsRETIRED
Top Expert 2006

Commented:
The session must be disconnected for the changes to take effect similar to login permissions. Microsoft should add the capability to force permission changes as they have with GPOs
Robert SilverSr. Software Engineer

Author

Commented:
Okay so this is specific to Windows? I had not thought of that
Distinguished Expert 2017
Commented:
Microsoft used as an example, the mysql is the one enforcing the active session rights in the posed question.

On MS as long as you are accessing local resources, your rights are not re validated, if you attempt to access another resource rights will be checked and access denied in the example provided.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial