[Zope-DB] ZPT, ZSQL & Proxy-Roles

Dieter Maurer dieter@handshake.de
Fri, 10 Jan 2003 21:21:17 +0100

Charlie Clark wrote at 2003-1-10 10:58 +0100:
 > as part of my application users have the opportunity to have save report
 > profiles and have them sent regularly by e-mail. I'm using Xron to do this
 > which while far from perfect seems adequate once the Proxy roles have been
 > configured correctly. There seems to be a problem, however, when it comes
 > to generating the reports - it seems that PageTemplates have a really
 > restricted status and can't even run ZSQL-queries:
You can execute ZSQL queries in Page Templates, provided you
are a user with the required permission.

We do this routinely...

Move the ZSQL call into a Python Script when you need proxy roles.