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