Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

MySQL 5.6 question about revoking an active session

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??
0
Robert Silver
Asked:
Robert Silver
1 Solution
 
Rick HobbsRETIREDCommented:
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
0
 
Robert SilverAuthor Commented:
Okay so this is specific to Windows? I had not thought of that
0
 
arnoldCommented:
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.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now