User Permission and ODBC

[ppetsinis]

Before, I describe the issue, I must compliment the team at SQLyog on a great product. Although, I have only been using it for a short time (about 4 hours) it was very easy to learn and become familiar with it.

Here is the problem/enhancement request. I've been searching for a MySQL DB admin tool that will allow me to manage user permissions down to a field level which your product does. Any DDL or DML statements that I attempt to execute within SQLyog support the defined user permissions. However, when I use MySQLCC the persmissions are totally ignored. This is also true when I attempt to access the database through ODBC using a number of third-party tools. My intent is to offer my clients the ability to access their data through ODBC with the option to restrict a specific set of users to sensitive data (Financials or salary amount column for Payroll) using a tool such as SQLyog.

Enviornment Info

MySQL version is 4.0.13-nt

MySQL ODBC Driver 3.51.06

OS Windows 2000 Server 5.00.2195 SP 4

Thanks in Advance and keep up the Great Work !!!!

Paul

[Shadow]

What is the question? If you want to find a complete end-user interface for MySql designed for data entry, I must disappoint you: there is no such general tool, you have to write your own. The available front-ends are admin tools, although you may use them for data entry. SQLyog might have such capabilities in the distant future.

Connections made via ODBC are subject to MySql's privilege system. If a product (third party or not) connects via ODBC and the access rules don't or seemingly don't apply to it, then something is terribly wrong vith that app, or with the configuration of MySql, or worse, with MySql…

[Author]

Posts