'Is it possible to assign all schemas to a single login without specifying?

I work with a DB where schemas get added and removed regularly, and preferably I would be able to assign all schemas to a single user with a script.

but as far as I can see, I always have to specify the schema like

ALTER AUTHORIZATION ON SCHEMA::schema_name TO myUser;

Is there a workaround?

sqlsql-server


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions