Error 1143 when CREATE VIEW

[Jack Ling]

Hi,


I've problem creating a View w/ a Union select clause.

I can't do this:

Create view v as select name from employee union select name from customer;

An error message:
"ERROR 1143 (42000): create view command denied to user 'root'@'localhost' for column 'name' in table 'employee'"

For simple illustration, the datatype of the fields are same (VARCHAR)

I've no problem creating a view for just a simple select statement (i.e. not UNION)

I don't understand why the problem. Pls guide me. Thanks.

using MySQL 5.0.1.

best regards,
jackling