DBD::Oracle - rt13865.t

2012-12-13 Thread Scott 


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

Re: DBD::Oracle - rt13865.t

2012-12-13 Thread Martin J. Evans 

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

Re: DBD::Oracle - rt13865.t

2012-12-13 Thread Scott 

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

Re: DBD::Oracle - rt13865.t

2012-12-14 Thread Martin J. Evans 

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

Re: DBD::Oracle - rt13865.t

2012-12-14 Thread Scott 

On 12/14/2012 03:52 AM, Martin J. Evans wrote:

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?
Yes, I just wanted to report that the test works without out the check 
for the DROP privileges.




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