You would not be able to run about 99% of the test with a Read only account.
There is all sorts of thinge going one , table create drop, insert delete slecect so a read only client will not cut it. If the Makefile.PL and the make worked It would be normally quite safe to ues for simple selectes. just use a make install to set it up on your system. cheers John Scoles compiled > I can connect to the database using sqlplus as user oracle, but not as > root. > > I can compile DBD::Oracle but not complete the test. > > I tried to set variables properly: > > ORACLE_HOME=/u/oracle/10.2.0 > ORACLE_HOST=hostname > ORACLE_PORT=1522 > ORACLE_SID=databasename > ORACLE_USERID=user/passw...@databasename > PATH=/u/oracle/10.2.0/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/root/bin > PWD=/usr/src/pub/dbd-oracle/DBD-Oracle-1.22 > TNS_ADMIN=/u/oracle/10.2.0/network/admin > TWO_TASK=T:hostname:ORACLE_SID > > The machine has a medium sized production Oracle 10g database which works > fine with a Java application. > > The # perl Makefile.PL appears to work and the make appears to work > > I have a user name/password which permits read-only access to the database > which I have verified as user oracle. > > I would appreciate any help, > > Jeff > >
