MySQL Forums
Forum List  »  MySQL Administrator

Err 1142 ANY command denied to user
Posted by: WebPat ME
Date: August 13, 2009 07:57AM

I get the following error when trying to execute a script containing a single CREATE VIEW statement.

#1142 ANY command denied to user 'me'@'localhost' for table mytable.

I get the error when trying to install a View at my ISP. The View works on my own local computer. I am able to create a very simple View (at the ISP) on the same table.

The View contains multiple Joins, although with testing I am able to get the error with a single join. The "ANY command" referred to in the message, although not well indexed in the documentation, seems to involve Subqueries. It is documented as equivalent to "=". The View DDL has no subqueries or "ANY" commands, but it does have "=" defining the joins.

I seem to have permission to access the table and to create views. Is there some other permission that is Denying the "ANY command" to me?
I believe the ISP is running v5.0.67.

Options: ReplyQuote

Written By
Err 1142 ANY command denied to user
August 13, 2009 07:57AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.