[Zope-DB] How to import SQL in python script?

[Charlie Clark]

On 2003-02-10 at 06:05:45 [+0100], eijgnit@netscape.net wrote:
> Hi, I would like to use python to dynamically query a database.
...
> import the SQL Method class is with:
>     from Products.ZSQLMethods.SQL import SQL
> 
> Error Value: You are not allowed to access SQL in this context
> 
> How do I set the permissions such that I could import the SQL object? I 
> don't have access to the LINUX system to modify the SQL.py file.

Could you provide a bit more detail about what you're trying to do? It 
sounds like you might be trying to use some Python module in a part of Zope 
that doesn't allow it; that's why Zope's security doesn't let you. You 
don't need to worry about the operating system permissions on the SQL.py 
file. It's normally best to use a ZSQL-method do the work and call this 
from a PageTemplate or a PythonScript. Importing the module directly is 
more relevant for external methods, I think.

Charlie