[Deploying Sakai] sakai and oracle

Jim Eng jimeng at umich.edu
Tue Apr 21 20:07:26 PDT 2009

Hi Dario,

Other people will give answers with more specifics about grants and  
such.  I can tell you that it is definitely possible to run with a  
user that has no ddl privileges.  I think most larger sakai instances  
do not do much ddl from within the sakai code and have ddl turned off  
for production.  It is easiest to use auto-ddl to create tables and  
indexes, but that means collecting all the ddl scripts and running  
them.  It is much easier to let sakai do that and then turn auto-ddl  
off as you suggested.


On Apr 21, 2009, at 10:58 PM, Dario P 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