MySQL Forums
Forum List  »  Security

user permissions
Posted by: Ясен Вилиев
Date: January 06, 2019 04:53PM

Here is the case.
I have mysql user which has from server privileges only RELOAD.
This user has access only to one database.
This user has granted with all the permissions to this specific database.
After some time, I decided to revoke INSERT privilege from only one specific table.

It was not possible, because mysql could't find INSERT to be granted to this table.
I decided to try to redeclare privileges by granting all permission except INSERT to this specific table. But without luck. I was still able to insert rows.

So is there a intelligent way to redeclare already inherited privileges on database level for specific table?

Or I have to revoke all privileges on database level first and then grant for every single table what I want?

Options: ReplyQuote

Written By
user permissions
January 06, 2019 04:53PM
January 06, 2019 07:24PM
February 02, 2019 06:39AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.