• If I recall (I don't have a test setup for this), you just need to grant CREATE TABLE (PROCEDURE, VIEW, etc.) to the login, then grant CONTROL on the schemas that you want to allow them to create these objects in. There may be a lower permission that you can grant on the schemas, but this should cover it. Some testing will need to be done, of course.