Re: block privileges

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

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]