Sorry guys,
It seems to be working now with just CREATE VIEW grant. I dont know how it didnt work earlier.