Re: [Gusdev-gusdev] Re: LoadTaxon.pm

[Arnaud K. <ax...@sa...>]

Another thing. At some point the code is trying to analyse the 
SRes.TaxonName table. I've got an insufficient privileges error.

I've got two database logins which are used for connecting the database 
from the perl object layer:
* databaseLogin=GUSrw
* readOnlyDatabaseLogin=GUSro

I guess the effective login to populate GUS is GUSrw, is that correct?
Probably a question for you Martin. Does GUSrw have enough privileges to 
execute analyse table statements on any schemas (in particular the SRes 
shema) ?

Arnaud

---------------------->
DBD::Oracle::db do failed: ORA-01031: insufficient privileges (DBD 
ERROR: OCIStmtExecute) at /nfs/team81/axk/projects/
gus/gus.deployment/lib/perl/GUS/Common/Plugin/LoadTaxon.pm line 304, 
<NODES> line 2.
<----------------------

line 304:   $dbh->do("analyze table sres.TaxonName compute statistics");

Deborah F. Pinney wrote:

>I didn't experience this problem. However, in looking over the
>LoadTaxon.pm code I noticed that there was still a commented out line
>that should have been corrected. This line is used only for restarting.
>I have uncommented it and submitted to cvs. Please update your file.
>
>                                             Deborah Pinney
>
>
>
>  
>