79707355

Date: 2025-07-19 15:34:20
Score: 2
Natty:
Report link
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 ?
Reasons:
  • Has code block (-0.5):
  • Ends in question mark (2):
  • Low reputation (0.5):
Posted by: VictorEspina