I'm very green when it comes to the world of database permissions management in SQL Sever.
Let's keep an example simple.
Say account 'admin' is the owner of schemas A, B, and C.
There another account 'minion' that you want to have full rights (update/delete/insert/select/alter) on any object (table/view) created under schemas A, B, and C.
Is this possible? Or do you have to execute a grant statement each and every time you add a table/ view under these schemas? (seems a bit silly to me).