Dear HANA friends,
Using the System user, we already created the 'efashion' project, starting with 'efashion_create_schema.sql.'
We are starting the training to the wider team, and idea is if the we create test users, say test1, test2... testn, and all get the "same" sql file.
Question is, will it create a new 'efashion' schema for every user, and thus a good idea for wholistic training (from schema creation to views, to reports) ? Or a one schema name in one database will prevail, so running the same schema creation sql will overwrite it, even if ran by different users?
to fully separate users from each other you should adjust the tutorial to not use efashion schema but to use users schema. Each user should have it's own schema and it's own package. This way he can destroy only his work and not work of others.
If you keep the efashion schema then users will be overwriting the same schema again and again during import.
Alternative is to keep it as central schema for all users and grant users only read privileges and to show import operation on presenter screen only (users will not have opportunity to try themselves).