Peter Teunissen wrote:
Hi All,
I'd like to restrict queries using the username of the user that issued
the query. I know about the available user restrictions in the database,
but they seem limited to whole tables and columns. What I need is
limiting the access on row level. If I can access the username, I'd be
able to limit access by using views for example. Can this be done? Is it
documented somewhere?
Try the CURRENT_USER() function. But if you use replication, beware --
I think it doesn't replicate correctly. (Check the manual).
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]