why need select privileges on *.* to use view?
- by profy
I have a problem using view with MySQL server 5.0 (5.0.92)
I cannot use view with a user granted like that :
GRANT USAGE ON *.* TO 'testuser'@'' IDENTIFIED BY PASSWORD '**********';
GRANT ALL PRIVILEGES ON `testuser`.* TO 'testuser'@'';
I can create view, but when I try to select in, I have this messages :
ERROR 1356 (HY000): View 'testuser.v' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
I need to "GRANT SELECT ON . TO 'testuser'@''" to make select working on the view.
Why ?
Do you know a solution to use VIEW's without the select privileges on . ?
Thanks a lots for your answers.
