You can grant those permissions on columns but not on individual rows. -----Original Message----- From: Marco Lazzeri To: [EMAIL PROTECTED] Sent: 5/20/04 10:04 AM Subject: Limit operations by condition
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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
