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: [email protected] <[email protected]>
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
--
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]
