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
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
Since there was no reply, I will try once more.
I wish to limit table access and data manipulation strictly through
procedures. Can MySQL 5 offer this?
If a user connects to the db and executes "UPDATE" or "DELETE" it should
not allow it, except by calling a procedure e.g.
"CALL DELETE_USER($u
