Skip navigation links

MySQL Forums :: Knowledge Base :: error code 1356 - invalid table/view


Advanced Search

error code 1356 - invalid table/view
Posted by: BN Vo ()
Date: October 15, 2007 11:06AM

hi,

I have a problem to open and/or describe table. The errors I had are


mysql_stgssl>desc ATL1_USER_DETAILS_VW;
ERROR 1356 (HY000): View 'atl1.ATL1_USER_DETAILS_VW' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
mysql_stgssl>select * from ATL1_USER_DETAILS_VW;
ERROR 1356 (HY000): View 'atl1.ATL1_USER_DETAILS_VW' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
mysql_stgssl>

How can see who own the table? Can someone show me how to pull the data dictionaries chart for MySQL??? I used to select table_name, owner from dba_tables in Oracle but I don't know how to do it in MySQL

Thanks,

bvo

Options: ReplyQuote


Subject Views Written By Posted
error code 1356 - invalid table/view 17458 BN Vo 10/15/2007 11:06AM
Re: error code 1356 - invalid table/view 8778 Ryan Lowe 12/23/2007 12:04AM


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.