Re: block privileges
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]
Re: block privileges
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]
block privileges
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]
Re: block privileges
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]