Solved

MySQL 5.6  question about revoking an active session

Posted on 2014-02-28
3
271 Views
Last Modified: 2014-03-15
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
Comment
Question by:Robert Silver
3 Comments
 
LVL 22

Expert Comment

by:Rick Hobbs
ID: 39896643
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
 
LVL 2

Author Comment

by:Robert Silver
ID: 39896953
Okay so this is specific to Windows? I had not thought of that
0
 
LVL 77

Accepted Solution

by:
arnold earned 500 total points
ID: 39897303
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MySQL database data submission 7 65
Mysql Crashing Intermittently 16 102
Easy to use inventory management software 7 92
Insert values are dynamic 11 41
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Creating and Managing Databases with phpMyAdmin in cPanel.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now