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

On Jul 29, 2008, at 00:18, 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().

That would be nice.

At least the README should then spell out what rights are needed by  
the test user.  Currently it says:

   So you should set that to a valid user (e.g. 'scott/tiger') and  
ensure that
   this user has sufficient privileges to create, insert into, select  
from and
   drop a table, and is able to select from systemtables like 'v 
$sessions'.

so it sounds like privileges to manipulate tables is all it takes.  I  
did not have test failures with 1.21, so this privilege is a new  
requirement for the test user in 1.22.

Unfortunately for me I don't have the powers to grant anything to my  
test user and the person that has the power is on vacation :(

--Gisle