Re: ALTER TABLE Denied

On 06/03/2016 06:57 AM, Jim Taylor wrote:
> I have an app that uses a local database but am moving it to a remote
> database.  I believe I have everything setup correctly regarding the
> connection as I can connect using Workbench and alter tables successfully.
> The problem is that when I try altering tables via the ODBC  connection,
> using the same credentials, I get the Alter Table Denied message.   The
> process is tried and true so am reasonably certain I am going wrong in some
> other fashion.   I have granted permissions via CPanel and assume I couldn't
> make the changes via Workbench if the GRANT wasn't done properly.
> Suggestions?

Hi Jim,

I have noticed that some operations are not supported with the ODBC
adapter. So that might be your limitation there. I have only ever used
the ODBC adapter for SELECT, INSERT, and UPDATE.

Simon

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc