Forum OpenACS Q&A: Privileges error on Oracle 10g

Posted by Brian Fenton on 10/20/08 12:53 PM

Hi,

I'm installing the latest OpenACS (5.4.3) on an Oracle 10g database - it's my first OpenACS install in quite a while and I'm wondering has something changed in the installation process, as I'm seeing the following error.

create or replace view acs_object_type_supertype_map
ERROR at line 1:
ORA-01031: insufficient privileges

I did the usual grants (connect ,resource, ctxapp, javasyspriv, query rewrite as per this page http://openacs.org/xowiki/openacs-subsystem-install ) to my new user. They should be enough, shouldn't they? I can work around this by granting whatever privs needed, but just thought I'd ask here first.

I wonder could it be a 10g thing?

Any suggestions?

thanks
Brian

2: Re: Privileges error on Oracle 10g (response to 1)

Posted by Dave Bauer on 10/20/08 04:18 PM

Yes its something with 10g.

On my test instance I added

grant sysdba to the_user;
grant dba to the_user;
grant ctxapp to the_user;

This may or may not be the right thing for a production instance, but it works for my testing install.

3: Re: Privileges error on Oracle 10g (response to 2)

Posted by Brian Fenton on 10/20/08 04:44 PM

Hi Dave,

thanks for the reply! Yes, that was the workaround I mentioned. I can't quite figure why 10g needs that though. And as you say, far from ideal on a production system!

cheers
Brian

4: Re: Privileges error on Oracle 10g (response to 3)

Posted by Mario Aguado on 10/20/08 07:42 PM

Hi Brian, I install openacs with:

grant connect,ctxapp,resource,javasyspriv, query rewrite,create view,create synonym to &&NOMBRE_USUARIO;

Resource has unlimited tablespace and other privs.

5: Re: Privileges error on Oracle 10g (response to 4)

Posted by Brian Fenton on 10/20/08 08:02 PM

Thanks Mario!

That sounds like the right solution. I've updated the Xowiki install notes.

many thanks
Brian

6: Re: Privileges error on Oracle 10g (response to 5)

Posted by Mario Aguado on 10/21/08 12:34 PM

One thing more:
Dir packages/ref-timezones/sql/oracle/ must have write permission for group. It's for logs file of sqlloader.

7: Re: Privileges error on Oracle 10g (response to 6)

Posted by Brian Fenton on 10/21/08 12:40 PM

Gracias Mario! Very helpful.

Brian