Skip navigation links

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'@'domain.com' VIEW <view name> AS...

Command syntax: ALTER VIEW statement.

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/

Options: Reply•Quote


Subject Views Written By Posted
Views - Affected by 'root' accounts? 521 Leon Seaman 11/21/2012 06:17AM
Re: Views - Affected by 'root' accounts? 395 Devart Team 11/28/2012 02:04AM
Re: Views - Affected by 'root' accounts? 368 Leon Seaman 11/28/2012 07:07AM


Sorry, you can't reply to this topic. It has been closed.
powered by phorum

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.