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
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
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
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
-
