Re: I can't accessing existing view !
Posted by: Daniel Valdez
Date: June 22, 2022 10:51AM

Hi Amine,

Ensure that when you're calling the view in database2, you are using fully-qualified name "database.entity" since it looks like you are opening the connection using database1. Also this could be related to permissions on the user that is trying to access the view, please verify the privileges for the user (https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html).

FYI, it is recommended to use the latest version of Connector/NET, v8.0.29. The version you are using is already unsupported.

Daniel

Options: ReplyQuote


Subject
Written By
Posted
Re: I can't accessing existing view !
June 22, 2022 10:51AM


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.