MySQL Forums
Forum List  »  Security

Re: user permissions
Posted by: Georgi Kodinov
Date: February 02, 2019 06:39AM

As Peter mentioned mysql currently doesn't support partial revokes, i.e. granting a privilege at a higher level and revoking it at lower levels (e.g. grant INSERT to a database, but revoke it for a specific table from that database).
You currently need to grant at table level if you want to exclude a table from the grant.

Georgi "Joro" Kodinov
MySQL SrvGen team lead
Plovdiv, Bulgaria

Options: ReplyQuote


Subject
Views
Written By
Posted
2054
January 06, 2019 04:53PM
479
January 06, 2019 07:24PM
Re: user permissions
443
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.