Re: [Gusdev-gusdev] insufficient privileges on Core.Algorithm_SQ sequence

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Hi Kevin and Juan,
I don't know what could have caused this error, but I would try one of
these (or both):

Run the grantPermissions script ($GUS_HOME/bin/grantPermissions.pl) or
recreate the users (I used the create-gus-users.sql shown below).

[create-gus-users.sql]
--------------------------------------------------
--This is to create the users.
DROP USER GUSRW CASCADE;
CREATE USER GUSRW IDENTIFIED BY <password> TEMPORARY TABLESPACE TEMP
DEFAULT TABLESPACE users QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON
users;

DROP USER GUSdevReadOnly CASCADE;
CREATE USER GUSdevReadOnly IDENTIFIED BY <password> TEMPORARY TABLESPACE
TEMP DEFAULT TABLESPACE users QUOTA UNLIMITED ON TEMP QUOTA UNLIMITED ON
users;

--This is to grant permission to the users

GRANT CREATE SESSION TO GUSrw;
GRANT CREATE TABLE TO GUSrw;
GRANT CREATE VIEW TO GUSrw;
GRANT CREATE SEQUENCE TO GUSrw;
GRANT CREATE TRIGGER TO GUSrw;
GRANT CREATE SYNONYM TO GUSrw;
GRANT SELECT ANY TABLE TO GUSrw;
GRANT INSERT ANY TABLE TO GUSrw;
GRANT UPDATE ANY TABLE TO GUSrw;
GRANT DELETE ANY TABLE TO GUSrw;
GRANT CREATE SESSION TO GUSdevReadOnly;
GRANT SELECT ANY TABLE TO GUSdevReadOnly;
GRANT SELECT ANY TABLE TO GUSdevReadOnly;
--------------------------------------------------

Best wishes,
Pablo

-- 
-----------------------------
Pablo Nascimento Mendes
Research Scholar
Kissinger Lab
Department of Genetics
University of Georgia
C210 Life Sciences Bldg.
Athens, Georgia 30602
Phone:706 542-1447
E-mail: pa...@ug...

On Thu, 2004-07-15 at 18:52, Kevin Murphy wrote:
> Hi gusdev-gusdev list,
> 
> (I'm working on the same installation with Juan Perin, who has posted a  
> couple times in the last few days).
> 
> While following the VBI PDF guide to GUS installation, we've  
> encountered an error at the following step:
> 
> ga +meta --commit
> 
> After writing the </Core::Algorithm> tag (see full output below), there  
> is an error, apparently because the user does not have sufficient  
> privileges on the Core.Algorithm_SQ sequence.
> 
> I inserted a debug statement to look at DBH->{Username}, and it is  
> GUSrw.  Using sqlplus shows that GUSrw can't read this sequence, but  
> the sequence does exist in ALL_SEQUENCES.
> 
> What do you think has gone wrong with our installation?  We've been  
> guilty of some errors along the way (typos in config files, use of  
> vbi's properties file instead of deriving from the sample, etc) and had  
> to run the 'build' script a number of times.  Is it brittle?
> 
> Thanks,
> Kevin Murphy
> 
> - - - -
> 
> [gus@rad GUS]$ ga +meta --commit
>    <Core::Algorithm>
>      <name>GA-Plugin</name>
>      <description>GUS application framework for plugins</description>
>      <Core::AlgorithmImplementation>
>        <cvs_revision>1.49</cvs_revision>
>        <cvs_tag> </cvs_tag>
>        <executable>GUS::PluginMgr::GusApplication</executable>
>        <executable_md5>e291775acbf95c5ed6bae9024ad78e79</executable_md5>
>        <description>update for GUS 3.0</description>
>        <Core::AlgorithmInvocation>
>          <start_time>SYSDATE</start_time>
>          <end_time>SYSDATE</end_time>
>          <machine_id>0</machine_id>
>          <cpus_used>1</cpus_used>
>          <result>meta</result>
>        </Core::AlgorithmInvocation>
>      </Core::AlgorithmImplementation>
>    </Core::Algorithm>
> DBD::Oracle::db prepare failed: ORA-01031: insufficient privileges (DBD  
> ERROR: error possibly near <*> indicator at char 12 in 's\
> elect Core.<*>Algorithm_SQ.NEXTVAL from DUAL') [for Statement "select  
> Core.Algorithm_SQ.NEXTVAL from DUAL"] at /checkout/GUS/lib/\
> perl/GUS/ObjRelP/DbiTable.pm line 551.
> Failed preparing sql 'select Core.Algorithm_SQ.NEXTVAL from DUAL' with  
> error: ORA-01031: insufficient privileges (DBD ERROR: erro\
> r possibly near <*> indicator at char 12 in 'select  
> Core.<*>Algorithm_SQ.NEXTVAL from DUAL') at  
> /checkout/GUS/lib/perl/GUS/ObjRel\
> P/DbiTable.pm line 551
>           
> GUS::ObjRelP::DbiTable::getNextID('GUS::Model::Core:: 
> Algorithm_Table=HASH(0x86b2560)', undef) called at /checkout/GUS/lib\
> /perl/GUS/ObjRelP/DbiRow.pm line 535
>           
> GUS::ObjRelP::DbiRow::getNextID('GUS::Model::Core:: 
> Algorithm=HASH(0x86591d0)') called at /checkout/GUS/lib/perl/GUS/ObjRe\
> lP/DbiRow.pm line 606
>           
> GUS::ObjRelP::DbiRow::insert('GUS::Model::Core:: 
> Algorithm=HASH(0x86591d0)') called at  
> /checkout/GUS/lib/perl/GUS/Model/Gu\
> sRow.pm line 1677
>           
> GUS::Model::GusRow::submit('GUS::Model::Core:: 
> Algorithm=HASH(0x86591d0)') called at  
> /checkout/GUS/lib/perl/GUS/PluginMgr/\
> GusApplication.pm line 355
>           
> GUS::PluginMgr::GusApplication::doMajorMode_Meta('GUS::PluginMgr:: 
> GusApplication=HASH(0x80fbc2c)', undef) called at /chec\
> kout/GUS/lib/perl/GUS/PluginMgr/GusApplication.pm line 283
>           
> GUS::PluginMgr::GusApplication::doMajorMode('GUS::PluginMgr:: 
> GusApplication=HASH(0x80fbc2c)', undef) called at /checkout/\
> GUS/lib/perl/GUS/PluginMgr/GusApplication.pm line 192
>           
> GUS::PluginMgr::GusApplication::parseAndRun('GUS::PluginMgr:: 
> GusApplication=HASH(0x80fbc2c)', 'ARRAY(0x81049d0)') called \
> at /checkout/GUS/bin/ga line 11
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by BEA Weblogic Workshop
> FREE Java Enterprise J2EE developer tools!
> Get your free copy of BEA WebLogic Workshop 8.1 today.
> http://ads.osdn.com/?ad_id=4721&alloc_id=10040&op=click
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev