Hacker News new | ask | show | jobs
Ask HN: MySQL Permissions Management?
1 points by arctia 3495 days ago
Hi HN,

I would like to grant a set of users all access to a database, but deny permission on one column only. With MySQL's permission system, I would need to grant tables individually, and for the one table that I need to deny, I would need to grant columns individually.

I've been searching the web but I can't find anything that will manage permissions like this. Every time if a table gets added, the dba would need to add table permissions to all those users again.

Is there a management layer already out there? If not, would people be interested?