Re: ANNOUNCE: DBD::Oracle 1.22 Release Candidate 2

Martin Evans wrote:
> Tim Bunce wrote:
>> On Mon, Jul 28, 2008 at 05:35:14PM -0400, John Scoles wrote:
>>> Gisle Aas wrote:
>>>> On Jul 28, 2008, at 18:06, John Scoles wrote:
>>>>
>>>>> Ok hot off the press  RC2
>>>>>
>>>>> I have fixed as much as I can of the different compiler warnings 
>>>>> hopefully this will be a little better.
>>>>>
>>>>> You can find the RC here
>>>>>
>>>>> http://svn.perl.org/modules/dbd-oracle/trunk/DBD-Oracle-1.22-RC2.tar
>>>> I tried it on our Linux build box and got test failures in 
>>>> t/31lob_extended.t.  Any advice on what I need to do?
>>>> --Gisle
>>>>
>>>>  perl -Mblib t/31lob_extended.t
>>>> DBD::Oracle::db do failed: ORA-01031: insufficient privileges (DBD 
>>>> ERROR: OCIStmtExecute) [for Statement "CREATE OR REPLACE PROCEDURE 
>>>> p_DBD_Oracle_drop_me(pc OUT
>>> Ok that is an easy one. This is not a DBD::Oracle or DBI error it 
>>> simply means the user you are running the test as does not have the 
>>> privileges to create an stored procedure.  Grand your user some more 
>>> rights and the test should pass.
>>
>> Sure, but tests shouldn't fail just because of a lack of privs.
>> The test needs to detect that and do a skip().
>>
>> Tim.
>>
>>
> 
> That is my fault - I wrote that test and I didn't think about 
> privileges. I would attach a patch but it will probably be deleted from 
> this list so I've sent it to John and if anyone else specifically wants 
> it let me know.
> 
> BTW, there are a lot of other tests will fail for users with few 
> privileges - the worst being unable to create a table but there are 
> others like selects from v$session. I have not patched all those as well.
> 
> Martin

For anyone interested the tests which fail for limited privileges (i.e., 
create table privilege, connect, unlimited table space) are:

28array_bind
   attempts to create a sequence - not handled
t/31lob
   attempt to select from v$session - I think this one is handled
t/50cursor
   Can't determine open_cursors from v$parameter - handled
t/56embbeded
   tries to create a type - not handled

Martin
-- 
Martin J. Evans
Easysoft Limited
http://www.easysoft.com