Posted by jb on May 20, 2015; 2:17pm
URL: https://forum.world.st/How-to-create-a-lot-of-Store-reps-automatically-tp4826914p4827653.html

Hi Tom!
> Am 19.05.2015 um 21:25 schrieb Tom Robinson <[hidden email]>:
> …
> 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.
I think we should give it a try.
>
> 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:
This is no problem because we have got scripts for all these issues, which we used successfully in the last years. But we installed the Store-tables manually for each team. That is annoying and error-prone.
>
> I hope you find this helpful…
yes, thank you

Regards
Johannes

________________________________


Staatlich anerkannte private Fachhochschule
NORDAKADEMIE
Gemeinnützige Aktiengesellschaft
Köllner Chaussee 11
25337 Elmshorn

Vorstand:
Prof. Dr. Georg Plate (Vorsitzender), Dipl.-Ing. Jörg Meier (stellv. Vorstand)

Vorsitzender des Aufsichtsrats:
Dr. h.c. Hans-Heinrich Bruns

Sitz:
Elmshorn, Amtsgericht Pinneberg, HRB 1682


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