search

webyog / sqlyog-community

Webyog provides monitoring and management tools for open source relational databases. We develop easy-to-use MySQL client tools for performance tuning and database management. Webyog's solutions include SQL Diagnostic Manager for MySQL performance optimization and SQLyog for MySQL administration. More than 35,000 companies (including Amazon, IBM, Salesforce, AT&T, eBay, and GE) and 2.5 million users rely on Webyog's solutions to provide valuable insights into their databases. Webyog is an Idera, Inc. company.
https://webyog.com/
GNU General Public License v2.0
2.19k stars 322 forks source link

"Copy table..." disabled with read only user #2266

Closed mclaborn closed 3 years ago

mclaborn commented 3 years ago

SQLyog 13.1.7 mysql 8.0.21

I have a read-only user (only global privileges: Execute, Select, Show View) that I use most of the time in SQLyog. With that user, the "Copy Table(s) to Different Host/Database..." right click entry is disabled. What privilege is missing to make that work? It works fine with a fully privileged user.

ghost commented 3 years ago

Even though I am not part of the SQLyog team or affiliated in any way (not even an advanced user of SQLyog), I would like to comment based on my previous experiences with GitHub tickets in general.

From what I can tell based on my personal experience, it is usually preferred to post questions in the forum pages instead of a ticket here in this repository. You may want to wait for a reply from the webyog team to see what they recommend doing in your case.

sibwy commented 3 years ago

Please refer to the KB for the statements that are allowed in 'Read-Only' mode, here.

mclaborn commented 3 years ago

What confused me was the I had the read-only flag set on the database that was to be the source of a table copy operation. At least to me, read-only should allow copying FROM a table, but should not allow copying TO a table. Does that make sense?