Thanks both of you for the reply.
I have decided to atleast give it a try with CREATE/ALTER/DROP/UPDATE
TABLE/VIEW/SEQUENCE/SYNONYM/TRIGGER on its own schema and tablespace and
SELECT/CONNECT ofcourse.
I will inform you later if it works or not, but just want to tell I am
greatful for you replys.
Anders Andersson
>> ludovic(a)xwiki.org 2008-03-29 23:19:25
>>>
In single wiki mode (XWiki Enterprise) it will need read, write to the
minimum if you pre create the schema from an existing one. If not you
you will need schema read and write. I don't know which oracle
privileges that is.
Run it once with all privileges to get the database created in one
oracle instance. Import that DB in your corporate database. Deactivate
updateschema in xwiki.cfg.
Then give the oracle privileges one by one.
In multiwiki (XEM) the xwiki user needs to be a DBA to be able to
create
new users.
Ludovic
>> gabrielw(a)ngasi.com 2008-03-28 18:15
>>>
That is a known issue with xWiki and Oracle. As I understand it is
being
addressed for an upcoming release.
So at this point you must use an Oracle user named xwiki. If possible
you may use another Db such as
mysql,postgresql, or an embedded hsqldb.
--
Regards
Gabe Wong
NGASI AppServer Manager
JAVA AUTOMATION and SaaS Enablement
http://www.ngasi.com
NEW! 8.0 - Centrally manage multiple physical servers
Anders Andersson wrote:
Hello!
I have a question regarding the installation of XWiki. In the
installation instructions it says I must type these commands:
connect ...
create user xwiki identified by xwiki;
grant all privileges to xwiki;
However this wiki will be installed on a corporate network on their
database and application servers and therefor not possible to grant
all
privileges to xwiki. I wonder if it is possible to run
the wiki with
more restrictions on the user xwiki? Which privileges is enough for
xwiki to operate on the database correctly?
Thanks for your time and patients. I will be happy to hear from you
again
Anders Andersson
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
Ludovic Dubost
Blog:
http://blog.ludovic.org/
XWiki:
http://www.xwiki.com
Skype: ldubost GTalk: ldubost
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users