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. >> >> -- >> Sergiu Dumitriu >> http://purl.org/net/sergiu/ >> _______________________________________________ >> devs mailing list >> [email protected] >> http://lists.xwiki.org/mailman/listinfo/devs >> >> > > 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 > -- > View this message in context: > http://n2.nabble.com/Oracle-10g-Installation-real-world-permissions-tp4736131p4736159.html > Sent from the XWiki- Dev mailing list archive at Nabble.com. > _______________________________________________ > devs mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/devs 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 Cheers Peter _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
