Re: block privileges

2007-05-29 Thread Anoop kumar V
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 PROTE

Re: block privileges

2007-05-29 Thread Ricardo Conrado Serafim
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, Rica

Re: block privileges

2007-05-28 Thread Anoop kumar V
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