Re: How to disable some of the mysql query?

2008-11-28 Thread Steve Edberg
At 1:07 AM +0800 11/29/08, Wayne wrote: for example,one user has the 'select' right on talbe 'test'(innodb,million records),however,he sometimes execute query like 'select * from test'.That will slow down the whole database. Is there a way to disable some queries for some users? Or,mysql's author

How to disable some of the mysql query?

2008-11-28 Thread Wayne
for example,one user has the 'select' right on talbe 'test'(innodb,million records),however,he sometimes execute query like 'select * from test'.That will slow down the whole database. Is there a way to disable some queries for some users? Or,mysql's authority can be more detailed? thx