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

Collapse
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.

Collapse
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

Collapse
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.

Collapse
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

Collapse
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.
Collapse
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