469,939 Members | 2,344 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,939 developers. It's quick & easy.

Inability to Show Create View

When I execute the command "show create view" while logged in as root I
get this error:
"select command denied to user 'root'@'%' for column (a table that
from which the view draws part of its data)"

I can select the data from the column using the standard select syntax.
I can also get the data from the view itself by running it using the
normal select syntax.

I presume there is some corruption here. I am unable to find a way to
repair a view in a manner similar to optimizing or repairing a table.
Aug 15 '06 #1
1 4015
No bother wrote:
When I execute the command "show create view" while logged in as root I
get this error:
"select command denied to user 'root'@'%' for column (a table that
from which the view draws part of its data)"

I can select the data from the column using the standard select syntax.
I can also get the data from the view itself by running it using the
normal select syntax.

I presume there is some corruption here. I am unable to find a way to
repair a view in a manner similar to optimizing or repairing a table.
Due to better searching I found that this is likely caused by Bug
#20482. It is not a matter of corruption as I thought but rather a
problem internal to the engine that does not check the permissions
correctly. According to the last entry it should be fixed in 5.0.25.
Sep 1 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by vaidas gudas | last post: by
1 post views Thread by Steve | last post: by
4 posts views Thread by Generic Usenet Account | last post: by
4 posts views Thread by Marc the Demi-Programmer | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.