MySQL Forums
Forum List  »  Knowledge Base

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
26770
October 15, 2007 11:06AM
10822
December 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.