Yes, I know. Perhaps, I'm searching for workarounds. Il gio, 2004-05-20 alle 17:58, Victor Pendleton ha scritto: > 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]
