CREATE VIEW command denied to user

[sridharao]

I am using create view command. It works fine in my desktop with wampserver. On my host server, I face this error, "CREATE VIEW command denied to user..."

Apparently there is no rights or privileges to run this command. There is no feedback from my host.

I tried using this statement before create command

mysql_query("GRANT CREATE VIEW ON *.* TO 'user1'@'www.mysite.com'"); 

The error persists, any solution?

[kows]

talk to your host. if your user account doesn't have the permissions to do it, there isn't really anything you can do to get around it.

[sridharao]

My host responded that I don't have create view permission. I tried to get around the problem by inserting into specially created tables, but then this creates problems with multiple users and requires the tables to be locked. This itself has created new problems, I have opened a new thread to discuss that.