Forum OpenACS Q&A: Re: Privileges error on Oracle 10g
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!
grant connect,ctxapp,resource,javasyspriv, query rewrite,create view,create synonym to &&NOMBRE_USUARIO;
Resource has unlimited tablespace and other privs.
That sounds like the right solution. I've updated the Xowiki install notes.
Dir packages/ref-timezones/sql/oracle/ must have write permission for group. It's for logs file of sqlloader.