SQL: Give ALTER SCHEMA Permissions to a User

5/9/2018 9:08:17 PM

Allow a user to alter a schema (default schema in this case). Alter a schema allows a user to drop a table.

GRANT ALTER ON SCHEMA::[dbo] TO sql_username