From: Jorge Bastos
Date: November 2 2005 5:38pm
Subject: Fw: Updateable Views in 5.0.15
List-Archive: http://lists.mysql.com/win32/17713
Message-Id: <018b01c5dfd4$3d6a88e0$0301a8c0@hercules.decimalint.pt>
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit

Well... that is strange!


----- Original Message ----- 
From: "Melissa Dougherty" <melissa@stripped>
To: <win32@stripped>
Sent: Wednesday, November 02, 2005 5:17 PM
Subject: Updateable Views in 5.0.15


I'm getting an error when trying to update a view in 5.0.15.

SELECT command denied to user 'root@localhost' for column 'requestid' in 
table 'workforceplan_request'

Root has full access to all tables in the database.... why would this error 
come up when trying to update that table through the view?


Melissa