Re: DBD::Oracle - rt13865.t

On 13/12/12 17:46, Scott wrote:
> 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.

I do have drop any table privilege as I have the DBA role.

Can't you just ignore that test?

Martin

>
> 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
>>
>>
>


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