What level of security is needed to delete objects?

  • Thread starter Thread starter sjl
  • Start date Start date
S

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
 
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.
 
Back
Top