If you are using a classic SQL warehouse you would need this on when they try to use it, it won't automatically spin up in the background. This is why a Serverless SQL endpoint is recommended, then it just spins up for the queries to run. The users would need permision to use the Warehouse.