15 Mar
2010
15 Mar
'10
11:54 a.m.
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-tp47361…
Sent from the XWiki- Dev mailing list archive at Nabble.com.
15 Mar
15 Mar
12:02 p.m.
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/
12:08 p.m.
Sergiu Dumitriu-2 wrote:
On 03/15/2010 11:54 AM, NicolaNardino wrote:
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-tp47361…
Sent from the XWiki- Dev mailing list archive at Nabble.com.
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
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
1:33 p.m.
On 15/03/2010, at 9:08 PM, NicolaNardino wrote:
Sergiu Dumitriu-2 wrote:
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 11:54 AM, NicolaNardino wrote:
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-tp47361…
Sent from the XWiki- Dev mailing list archive at Nabble.com.
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
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
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
3:34 p.m.
On 03/15/2010 01:33 PM, Peter McLarty wrote:
On 15/03/2010, at 9:08 PM, NicolaNardino wrote:
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/
Sergiu Dumitriu-2 wrote:
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
On 03/15/2010 11:54 AM, NicolaNardino wrote:
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 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.
5396
days inactive
5396
days old
4 comments
3 participants
participants (3)
-
NicolaNardino -
Peter McLarty -
Sergiu Dumitriu