• ROUTINE_PRIVILEGES implementation

    June 22, 2011

    Following up on MySQL security: inconsistencies, and on MySQL bug #61596, I was thinking it may take a long time till the non-existent ROUTINE_PRIVILEGES view is implemented. Here's my own implementation of the view. I've followed the somewhat strange conventions used in the *_PRIVILEGES tables in INFORMATION_SCHEMA, where the IS_GRANTABLE is a separate column, although […]

  • MySQL security: inconsistencies

    June 22, 2011

    Doing some work with MySQL security, I've noticed a few inconsistencies. They're mostly not-too-terrible for daily work, except they get in my way right now. The ALL PRIVILEGES inconsistency The preferred way of assigning account privileges in MySQL is by way of using GRANT. With GRANT, one assigns one or more privileges to an account, […]

  • MySQL User Group Meeting, June 2011, Israel

    June 18, 2011

    It's been quite a while since a MySQL User Group Meeting was held in Israel. I'm happy to announce that the next meeting will take place on June 28th, starting 16:30. Talks will be in Hebrew. Full details here. This meeting is organized by Valinor, who will also be hosting it, and who are planning […]

  • Pop quiz: what is the most basic privilege an account can be assigned with?

    June 14, 2011

    I asked this during my presentation on the MySQL Conference this year. And I got a unanimous answer from the crowd. Take a moment to think this over, before coming up with the answer. Meanwhile, an intermezzo. Tam dam dam... Pom pom Pom pom Pom pom... If your answer is that the most basic privilege […]

 
Powered by Wordpress and MySQL. Theme by openark.org