• Article for your preferred language does not exist. Below is international version of the article.

Article ID: 113106, created on Jan 10, 2012, last review on May 4, 2016

  • Applies to:
  • Operations Automation

Symptoms

A view created in a hosted MySQL database cannot be used afterwards by the same database user. The following error is displayed:

CREATE VIEW temp_view as 
SELECT * from TEMP_TABLE1;

SELECT * FROM temp_view;
ERROR 1356 (HY000): View 'db1004420_test_customer.temp_view' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

Resolution

Explicitly specify that the INVOKER security model is to be used while executing the view as shown below:

CREATE SQL SECURITY INVOKER VIEW temp_view as
 SELECT * from TEMP_TABLE1;

See also

Access Control for Stored Programs and Views MySQL VIEW access problem

Search Words

MySQL API error: SELECT command denied to user

Problem accesing phpmyadmin in hardware node mysql14.acens.net

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF