MySQL Forums :: Views :: Views - Affected by 'root' accounts?

Advanced Search

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

Subject Views Written By Posted
Views - Affected by 'root' accounts? 3094 Leon Seaman 11/21/2012 06:17AM
Re: Views - Affected by 'root' accounts? 1256 Devart Team 11/28/2012 02:04AM
Re: Views - Affected by 'root' accounts? 1031 Leon Seaman 11/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.