MySQL Forums
Forum List  »  Views

Re: Views - Affected by 'root' accounts?
Posted by: Devart Team
Date: November 28, 2012 02:04AM

Maybe view has wrong DEFINER; to check this, run SHOW CREATE VIEW statement -

SHOW CREATE VIEW <view name>

If DEFINER is 'root'@'%', then alter this view in this manner -

ALTER DEFINER = 'root'@'' VIEW <view name> AS...

Command syntax: ALTER VIEW statement.

Devart Company,
MySQL management tools

Options: ReplyQuote

Written By
November 21, 2012 06:17AM
Re: Views - Affected by 'root' accounts?
November 28, 2012 02:04AM
November 28, 2012 07:07AM

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.