Hello. Does anyone know whether a Z SQL method has the permission to make modifications to already existing data by using the SQL update command. I am calling a Z SQL method that attempts to do this from a DTML method that has a proxy role of 'manager'. However, when this Z SQL method is called, Zope flags me with an error saying that I am "Unauthorized". Now, when I call another Z SQL method from this same DTML method that inserts records into the same database, everything works fine. Is there some restriction against modifying database records in Zope? Any help would be greatly appreciated. Thanks.
Zope doesn't really care about the contents of the SQL statement. The concepts of "insert" and "update" (and even "select") are entirely out of Zope's world. It is probably about permissions with the database user you have the ZSQL method logging in as. Can you do the same thing on the database console as the same user? --jcc