6

why need select privileges on *.* to use view?

view full story
linux-howto

http://serverfault.com – I have a problem using view with MySQL server 5.0 (5.0.92) I cannot use view with a user granted like that : GRANT USAGE ON *.* TO 'testuser'@'' IDENTIFIED BY PASSWORD '**********'; GRANT ALL PRIVILEGES ON `testuser`.* TO 'testuser'@''; I can create view, but when I try to select in, I have this messages : ERROR 1356 (HY000): View 'testuser.v' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them I need to "GRANT SELECT ON . TO 'testuser'@''" to make select working on the view. Why ? Do you know a solution to use VIEW's without the (HowTos)

taskli's picture
Submitted by taskli on 06/29/2012 – Made popular on 06/29/2012

Stories similar to why need select privileges on *.* to use view?

Cannot see aliases 45 weeks 6 days ago

I have my root user and another user testuser. Now in the .bashrc of testuser, there are some aliases like la for ls -a. But when I login to testuser and try running la, it gives me the error: -sh: la: not found

Even when I try to find $HOME, it says Permission denied (?)

This is slowing down my work!! Help!

I installed jailkit on my CentOS 5.8 server, and configured it according to the online guides that I found.

Customizing KDE 22 weeks 2 days ago

Hello,I'm using Androbit KDE's theme. But I don't like the folder view's background: is full black. Trying other themes, I have found nice the folder view's of Oxygen. Can I use the Oxygen's folder view in Androbit? How?Have a nice day,Grant.

Grant https://bbs.archlinux.org/profile.php?id=66618

2013-01-13T11:42:44Z

In Microsoft Windows Server 2003 Standard Edition, Service Pack 2:

Start > Run... > perfmon Select menu View > Customize... Uncheck option "Standard menus (Action and View)" Select button "OK"

How might I now restore menus Action and View to their default value?

Hi guys I have set up a small shared hosting set up for friends.

I have set the file chmod permissions to

chmod 711 /home chmod 711 /home/testuser chmod 755 /home/testuser/public_html chmod o+r /home/testuser/public_html/index.htm How do I stop the user connected to their own ftp from deleting the html.htm file and also with the public dir set to chmod 755 I find they can't do anything in the di

I found two ways of creating a Bitmap from a view. But once I do that, the view disappears and I can't use it anymore. How can I redraw the view after generating my bitmap?

I have just started using Jorte and quite like the look of it but I want to know if I can change the default view once you "click" into it from the main widget view??

Here is my widget as it displays on my phone:

Here is the default view that I've set it to once you select the calendar:

Here is the view changer with the numbers across the bottom and up the right hand sid

I have a view that, under some condition, is shifted to the right with

view.scrollTo(-shiftpixels,0).

How can I determine, if the view has been shifted (scrollTO)? Using view.getLeft() or view.getRight() yield the same result before and after shifting.

Any ideas to the above problem? Yes, I could tag the view, indicating it has been shifted, but is there any other way?

I have a RelativeLayout with a view inside. the view overtimes changes its position so my question is i'm running into an issue where say the top and left coordinates are say max height and max width and the view is displayed partially on screen while the rest is cut off .