RE: Table and Data access only through procedures

2005-08-10 Thread Mark Leith
K Limited http://www.cool-tools.co.uk http://leithal.cool-tools.co.uk > -Original Message- > From: Gleb Paharenko [mailto:[EMAIL PROTECTED] > Sent: 10 August 2005 09:55 > To: mysql@lists.mysql.com > Subject: Re: Table and Data access only through procedures > > Hello

Re: Table and Data access only through procedures

2005-08-10 Thread Gleb Paharenko
Hello. MySQL 5.0.10 offers modifying tables from stored procedures, however I've met some problems. I've tried to create a procedure like your DELETE_USER, but DROP USER seems to accept only literal strings, not variables, while direct modifying of GRANT tables and calling FLUSH privileges l