[Zope-DB] ZPT, ZSQL & Proxy-Roles
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.