"Although there is no way to limit table access on a per-use
basis in MySQL, you can use stored procedures to limit user access
to data. This is one of the many security workarounds that Scott
Noyes, SearchEnterpriseLinux.com's MySQL expert, suggests, in
addition to explaining the differences between user and local
variables and preventing privilege pass-alongs by users.
"Noyes is a MySQL Core-, Developer- and DBA-certified engineer.
He is also the senior Web applications developer for
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.