Percona Live Europe Presents: MariaDB 10.4 Reverse Privileges (DENY)

by Vicențiu Ciorbaru

MariaDB Foundation

One of the most common questions about privileges in MySQL and MariaDB is how would a user revoke access to a particular table, in a large database with hundreds or thousands of tables, while keeping the rest available. Currently, there is no easy solution. Just grant access to everything else, individually. Not only does this reduce server performance, but is a nightmare to maintain. Reverse privileges solve this and more. And they are simple to explain to new admins too! So I look forward to sharing the knowledge during my presentation at PLE18.

DBAs would benefit from this talk the most. As it is a feature still under development, we are open for input from the community. Tell us what you think we should do to make this feature the best it can be.

What I’m looking forward to…

 

It will be quite interesting to see what challenges people have faced with MySQL and MariaDB and how they were overcome. As a database developer, it’s always important to understand how your users make use of the product. It is only through this that we can make it better. ∎

Vicențiu Ciorbaru

Vicentiu works at the MariaDB Foundation as a Software Engineer and Team Lead. He focuses on optimizer development, but has also worked on other parts of the MariaDB Server. Vicențiu has been part of the MariaDB ecosystem since 2013, where he first contributed Roles to MariaDB. Over the years, Vicențiu has coded numerous features and helped with the packaging of MariaDB for various distributions. Recently, Vicențiu has also been involved in the QA process of MariaDB, by contributing to https://buildbot.mariadb.org as well as mariadb.org/download infrastructure

See all posts by Vicențiu Ciorbaru »

Discussion

We invite you to our forum for discussion. You are welcome to use the widget below.

✎ Edit this page on GitHub