[Deploying Sakai] sakai and oracle

Matthew Jones jonespm at umich.edu
Tue Apr 21 20:13:03 PDT 2009

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.



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"

More information about the production mailing list