On 03/15/2010 01:33 PM, Peter McLarty wrote: > > On 15/03/2010, at 9:08 PM, NicolaNardino wrote: > >> >> >> Sergiu Dumitriu-2 wrote: >>> >>> On 03/15/2010 11:54 AM, NicolaNardino wrote: >>>> >>>> Hi guys, >>>> I'm preparing a proper xwiki installation in my network on a shared >>>> Oracle >>>> 10g instance. Of course, it's ot of the world granting all privileges to >>>> the >>>> xwiki user, so I did some testing and found out that it just needs the >>>> roles >>>> connect and resource. As far as I could see, the oracle schema contains >>>> no >>>> procedures nor triggers or other objects but tables and indexes, and the >>>> hibernate sequence. >>>> >>>> Can anyone confirm it? >>> >>> Yes, that is true. Granting more rights is needed only in the initial >>> startup, which creates all the tables, and if you plan to have a XEM >>> which can dynamically create new wikis, thus new databases. >>> >>> >> >> Hi, >> As to the start-up, the role resource is enough to create the tables. I >> can't say on the XEM installation mode though. >> >> Regards >> Nicola >> -- > Hi All > > This will change for 11g, I will have a look and provide the feedback via the > comments on the Oracle Installation page. > > In 11g the resource role no longer provides any grants per se. The Xwiki user > will require either a role created as part of creating the user or using > explicit grants such as create table, create index >
Hi Peter, Thanks for the contribution. You could even change the actual document instead of commenting, the wiki is open for participation. -- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
