If I connect to the server remotely, I get an error when I try to view or edit a database view using dbForge. I only get this error if the view definer is root@localhost. The error says that it "Cannot obtain the SQL code for a view 'test_v'. Probably, you do not have enough privileges to get view metadata".
If I drop the view, and then recreate it while logged in remotely (i.e. view definer is root@%), I can then view or edit the view from within dbForge.
Both root@% and root@localhost have all privileges, including SHOW VIEW. Also, I don't get, and can't reproduce this error using other tools that I'm currently evaluating (Navicat and EMS SQL Manager), even if the view definer is root@localhost.
Is this a bug? If root@any has all privs, why does this not work with a view if the definer is root@localhost?
So far, I like dbForge better than the other tools, but I have to get past this issue before making a purchase.
Here is the DDL from the very simple test view I'm using (it just populates a single view row with system date):
Code: Select all
CREATE OR REPLACE
ALGORITHM = UNDEFINED
SQL SECURITY INVOKER
VIEW med.test_v
AS
/* ALGORITHM=UNDEFINED */ SELECT
NOW() AS `NOW()`;