User permissions for Microsoft SQL Server Please advice to give permission for a SQL server user. Conditions are, this user must be able to create,delete,modify,drop the tables/view/procedure on user default schema(not dbo) not in any other schema. I have given db_ddladmin privilege but here the user will be able to perform any action on other schema's as well.
GRANT CONTROL ON SCHEMA :: BobsSchema To Bob;


Where Bob is the users name. See MSDN.