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?
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?