I would like to grant SELECT/UPDATE/INSERT/DELETE privileges _only_ on particular set of rows.
The GRANT syntax I'm dreaming could be: GRANT SELECT, UPDATE, INSERT, DELETE ON table_a TO user_a WHERE table_a.foo = 'bar' I've tried using TEMPORARY TABLEs as follow: CREATE TEMPORARY TABLE table_a SELECT * FROM table_a WHERE foo = 'bar'; And it was good, but just for SELECT (I can't define rules on UPDATE/INSERT/DELETE to commit the modifies on the original table). If it was PostgreSQL, I will be using VIEWs with RULEs. Any hints? Thanks, Marco -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
