On 2007-02-28 Gary W. Smith wrote:
> Basically, here is the stored proc. It works, but only for root. Is it
> possible to allow user to execute this without having SELECT access to
> the table users? If so, how?
Do you know about the "SQL SECURITY { DEFINER | INVOKER }" options to
CREATE PROCEDURE? With them it should be possible to
* deny selects to users on the tables
* allow selects to users to this procedure
* having the procedure itself working with the rights of root/definer
bye,
-christian-
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
