[Deploying Sakai] sakai and oracle

[Matthew Jones]

Something similar was asked a month ago here, nobody really chimed in
much on it. To create the databases for the first time, the user will
need a lot of permissions, probably all of the grants. You really
probably want to start it up the first time with auto.ddl

After that, a user connected should only need select, insert, delete,
update. Try it out and let us know, you'd only get errors or parts not
working right if there's a problem, and it would be obvious.

http://www.nabble.com/-Building-Sakai--Error-during-tomcat-startup-td22427898.html

-Matthew

On Tue, Apr 21, 2009 at 10:58 PM, Dario P <dario_d_u at unitech.com.ar> wrote:
> Hello.
> Our deploy has an oracle database as backend . Regarding this, I would like
> to restrict privileges for the tables owner.
>
> Which minimun privileges should be granted to the user?
>
> Caveat emptor. I have found how to create a user for a mysql database, but I
> can't found which privileges should have for an Oracle database.
>
> I would like to know if it's posible to use an user with no ddl privileges
> once sakai is deployed.
>
> Example:
> create user sakai identified by averydifficultpass;
> grant create table to sakai;
> (generate sakai tables.)
> revoke create table to sakai;
>
>
> Greetings and sorry for my english.
>
> _______________________________________________
> production mailing list
> production at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/production
>
> TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
>