CODE
#1142 - CREATE VIEW command denied to user 'user'@'localhost' for table 'dbtable'
i thought view privilege would be assign when i checked the view box here:
Click to view attachment
Full Version: Mysql "create View" Privilege Not Workinng
whenever i try to create view it gives me this error:
i thought view privilege would be assign when i checked the view box here:
Click to view attachment
i thought view privilege would be assign when i checked the view box here:
Click to view attachment
how long is your mysql DB name?
which server are you on, vndv or uuuq?
QUOTE(Bread @ Dec 15 2008, 12:43 AM) 
which server are you on, vndv or uuuq?
uuuq
15 characters long
I don't know if it's a common problem but I'm unable to grant the VIEW privilege.
I really need to create a view for my application but it didn't work.
My DBname is "outilsrr_herautclerge", so 21 characters long.
My user to grant the privileges is : "outilsrr_root"
I try to revoke and grant again the privileges... nothing happen.
I really need to create a view for my application but it didn't work.
My DBname is "outilsrr_herautclerge", so 21 characters long.
My user to grant the privileges is : "outilsrr_root"
I try to revoke and grant again the privileges... nothing happen.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.