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 leads server to hang. See my bug report: http://bugs.mysql.com/bug.php?id=12485 Terence <[EMAIL PROTECTED]> wrote: > 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($user_id)" > > Since my database is being called through Oracle, VB, ASP and PHP > applications, it's becoming increasingly difficult to ensure data > integrity (and auditing). > > Any tips would be great. > > > -------- Original Message -------- > Subject: Tabls access only through procedures > Date: Thu, 14 Jul 2005 17:10:51 +0800 > From: Terence <[EMAIL PROTECTED]> > To: mysql@lists.mysql.com <mysql@lists.mysql.com> > > Hi List, > > I belive version 5 does not allow me to grant access to execute > procedures, but deny updates to tables directly? I am attempting to > ensure that > all data modification is done through procedures. Any tips or ideas when > this will be available or work-arounds? > > Thanks, > Terence > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]