title: How can I restrict CREATE TABLE access for a user to a specific schema (sql server)?
body: <p>I'd like to allow some users to create tables in a particular schema, but not be able to create tables in other schemas. How can I achieve this? </p>
  
  <p>I see the <a href="http://msdn.microsoft.com/en-us/library/ms174979%28SQL.90%29.aspx" rel="nofollow">CREATE TABLE</a> help says </p>
  
  <blockquote>
    <p>Requires CREATE TABLE permission in the database and ALTER permission on the schema in which the table is being created.</p>
  </blockquote>
  
  <p>Does that mean I can give ALTER permission to the schema and restrict ALTER permissions on all other schemas? </p>