Re: Limit operations by condition

2004-05-20 Thread Marco Lazzeri
Hi Sasha, I've tried writing a python wrapper but It's an hard work because I've to wrap every type of queries, join, where, order, group and any other MySQL 4.0 clause. Have you ever written or used a wrapper like the one I need? Anyone knows a simple way for developing it? This is not just a SE

Re: Limit operations by condition

2004-05-20 Thread Sasha Pachev
Marco Lazzeri wrote: 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. Marco: Your choices are limited to creating a wrapper for your users. If they have direct ac

RE: Limit operations by condition

2004-05-20 Thread Marco Lazzeri
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 us

RE: Limit operations by condition

2004-05-20 Thread Victor Pendleton
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

Limit operations by condition

2004-05-20 Thread Marco Lazzeri
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_