MySQL Forums
Forum List  »  Connector/ODBC

Re: Secured ODBC Connection with mySQL 4.1
Posted by: Jim Winstead
Date: July 23, 2007 11:05AM

I'm not sure what this has to do with "secure ODBC connections," but if you want a user to only be able to access specific rows of a table, you must use a VIEW, which is not available in MySQL 4.1.

If you want the user to only be able to access specific columns, you can grant permissions on specific columns using GRANT. See http://dev.mysql.com/doc/refman/5.0/en/grant.html

None of this is specific to ODBC.

Jim Winstead
MySQL/Sun

Options: ReplyQuote


Subject
Written By
Posted
Re: Secured ODBC Connection with mySQL 4.1
July 23, 2007 11:05AM


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.