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

Collapse
Posted by Brian Fenton on
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
Posted by Mario Aguado on
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
Posted by Brian Fenton on
Thanks Mario!

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

many thanks
Brian

Collapse
Posted by Mario Aguado on
One thing more:
Dir packages/ref-timezones/sql/oracle/ must have write permission for group. It's for logs file of sqlloader.
Collapse
Posted by Brian Fenton on
Gracias Mario! Very helpful.

Brian