block subqueries? I do not think that one is possible in mysql (or any other db IMO).
Also - I wonder why would you want to block subqueries but allow normal queries - surely most (if not all) subqueries can be rewritten using JOINs right. Anoop On 5/29/07, Ricardo Conrado Serafim <[EMAIL PROTECTED]> wrote:
Thanks!! It helps me a lot!! But now, I just need to know how I do to block subqueries (if it's possible...) ======== Anoop kumar V escreveu: > http://dev.mysql.com/doc/refman/5.0/en/revoke.html > > You can use: > > REVOKE ALTER ROUTINE, CREATE ROUTINE, EXECUTE ON * TO USER; > > Anoop > > On 5/28/07, Ricardo Conrado Serafim <[EMAIL PROTECTED]> wrote: >> Hi, >> >> I need to know if it's possible block things like store procedures, >> triggers, etc in MySQL 5.0 using grant statement. Some users can't uses >> this stuff. >> If someone knows please help me. >> >> Regards, >> >> -- >> Ricardo Conrado Serafim >> DBA Júnior (MySQL) >> URANET Projetos e Sistemas >> www.uranet.com.br >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> >> > -- Ricardo Conrado Serafim DBA Júnior (MySQL) URANET Projetos e Sistemas www.uranet.com.br -- 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]