I am wondering is this can be used to implement environmental separation inside the same datatabase, like:
dev.customers
qas.customers
prd.customers
If a user logos on the QAS environment, I would just run:
ALTER USER [yourUser] WITH DEFAULT_SCHEMA = qas;
and then the user will run the app using a test dataset.
Is this a good idea or am I utterly mistaken ?