"Mahdi A. Sbeih" wrote:
> I am trying to access an Informix database, that I have only connect
> permissions,
> and I am trying to 'eval' the code below, but for some reason that I can't
> identify,
> no error occurred in the first 2 select statements, the error occurred at
> third
> SQL statement, which is drop table. When running any of the first 2 select
> statments manually, I got an error that I don't have permissions.
...further to my previous response...
If you run the SELECT manually and get a 'no permission' error, then you must be
connecting to the database in a very odd way -- you don't show how you connect
in the Perl code, nor how you connect 'manually' (is that DB-Access or something
else)? Are you sure you are using the same connection method? User ID? If the
SELECT fails with a no permission error, I'm really puzzled;
you can always interrogate the system catalog.
--
Jonathan Leffler ([EMAIL PROTECTED], [EMAIL PROTECTED])
Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/
#include <disclaimer.h>
