Posted by Tom Robinson-4 on May 19, 2015; 7:11pm
URL: https://forum.world.st/How-to-create-a-lot-of-Store-reps-automatically-tp4826914p4827489.html

Hi Johannes,

I'm sorry to tell you that there isn't a good way to do this.  One thing
you might consider is this:  Postgres can create a new database in the
server using another database as a template.  You might try creating one
database, installing the store schema into it and then using it as a
template to create the others. Please see the Template Databases section
in the online documentation for this.

One issue with a single server having 50 databases on it is that the
current Store setup grants SELECT, INSERT and some UPDATE permissions to
PUBLIC. This means that everyone will have access to all of the
databases. To fix this you would need to remove those privileges from
PUBLIC and GRANT them to a ROLE you create as the group role for the
students using a particular database.  You would then need to grant that
ROLE to all of the users for each database. The code that grants the
permissions can be found in
PostgresPlatform>>grantStoreSpecificPermissionsSQLUsingAccessor: .  This
method is called from Store.Glorp.StoreDescriptorSystem>>createTablesFor:

I hope you find this helpful...

Regards,

Tom Robinson

On 5/17/15 1:26 PM, Johannes Brauer wrote:

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc