MySQL Forums
Forum List  »  Connector/ODBC

Secured ODBC Connection with mySQL 4.1
Posted by: Richard Hackathorn
Date: July 22, 2007 06:40PM

mySQL 4.1 does not support CREATE VIEW. Hence, you can not grant read access via ODBC in a secure manner. For instance, if someone can only see part of a base table rather than all rows, you must use a VIEW. Therefore, you must use mySQL 5.0 or 5.1 for secure ODBC connections.

Is this correct?

Options: ReplyQuote

Written By
Secured ODBC Connection with mySQL 4.1
July 22, 2007 06:40PM

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.