balasach82 (3/26/2015)
How to grant DROP table permission within a database to an SQL login. I could see in Databae properties-> permission tab, there is an option to grant CREATE TABLE, EXECUTE permission etc, but not DROP table permission. How to grant it?
To drop a table, the user needs either CONTROL on the table, or ALTER on the schema like so
GRANT CONTROL ON OBJECT::[dbo].[bob] TO [someuser]
GRANT ALTER ON SCHEMA::[dbo] TO [someuser]
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉