SQL Server - granting permissions to an entire schema vs. object?
You can GRANT schema permissions that are effective for everything existing and everything that will exist in that schema.

Grant Schema Permissions

GRANT SELECT, INSERT, UPDATE, DELETE ON SCHEMA :: &lt;schema&gt; TO &lt;user&gt;;


Further to that, if you want to then deny permissions on a certain object within that schema, you can do.

Denying Object Permissions

DENY INSERT ON OBJECT::&lt;schema&gt;.&lt;object&gt; TO &lt;user&gt;;