Re: DBD::Oracle - rt13865.t

Do you have the DROP ANY TABLE privilege set for the userid?
That is the only DROP TABLE priv I can see, so  I probably need to have 
the dba grant it to my install-test user.


On 12/13/2012 11:03 AM, Martin J. Evans wrote:
> On 13/12/12 16:38, Scott wrote:
>>
>> I have to comment out the 'DROP TABLE' check to get this test to run. 
>> In Oracle, AFAIK, there is not a
>> DROP TABLE privilege.  If you can create it, you can drop it. Does 
>> this test not run for everyone?
>>
>>
>>   unless (    ( $priv{'CREATE TABLE'} or $priv{'CREATE ANY TABLE'} )
>> ){
>> #        and ( $priv{'DROP TABLE'} or $priv{'DROP ANY TABLE'} ) ) {
>>      plan skip_all => q{requires permissions 'CREATE TABLE' and 'DROP 
>> TABLE'};
>> }
>>
>>
>> Scott
>
> Works and runs for me:
>
> $ prove -vb t/rt13865.t
> t/rt13865.t ..
> 1..9
> ok 1 - INTEGER is alias for NUMBER(38)
> ok 2 - NUMBER(37)
> ok 3 - NUMBER
> ok 4 - VARCHAR(67)
> ok 5 - VARCHAR(69)
> ok 6 - NVARCHAR2(69)
> ok 7 - NCHAR(69)
> ok 8 - CHAR(67)
> ok 9 - CHAR(69)
> ok
> All tests successful.
> Files=1, Tests=9, 12 wallclock secs ( 0.03 usr  0.01 sys +  0.14 cusr  
> 0.07 csys =  0.25 CPU)
> Result: PASS
>
>