What level of security is needed to delete objects?

[sjl]

Does a user need to be the database owner in order to delete an object such
as a query or table? It doesn't appear as though giving a user admin rights
to the specific object allows them to delete it. Or, does the user need to
have delete rights to the MSysObjects table? Can that be done?

Thanks in advance,
sjl

 

[Joan Wild]

Users need 'administer' permissions to delete objects they don't own. If
they are owner of an object, it doesn't matter what permissions you assign,
as owner they have full control.