[xwiki-devs] Oracle 10g Installation, real world permissions.
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? Cheers Nicola -- View this message in context: http://n2.nabble.com/Oracle-10g-Installation-real-world-permissions-tp473613... Sent from the XWiki- Dev mailing list archive at Nabble.com.
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/
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-tp473613... Sent from the XWiki- Dev mailing list archive at Nabble.com.
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-tp473613... 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
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/
participants (3)
-
NicolaNardino -
Peter McLarty -
Sergiu Dumitriu