I've read the developers page regarding views on mysql and I've also
found that other people have had problems with creating views and
permissions but I still have a question as to how I achieve this.

I create a database using JDBC in my java program. Everything works fine
(creating tables) but when it gets to creating the view I am told that I
don't have enough permissions. This is doing it as normal user.

For usability reasons I would like to be able to do this as normal user,
is it possible?

thanks

Lionel.