Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 MS SQL Drop table Permission

Author  Topic 

Starting Member

1 Post

Posted - 2005-02-28 : 04:17:22
Is there any configuration for customizable permission requirements which prevents database users (inc. SysAdmin) from dropping the table(s)?

Most Valuable Yak

15732 Posts

Posted - 2005-02-28 : 07:21:46
From Books Online:

DROP TABLE permissions default to the table owner, and are not transferable. However, members of the sysadmin fixed server role or the db_owner and db_dlladmin fixed database roles can drop any object by specifying the owner in the DROP TABLE statement
Keep users out of these roles if you don't want them to drop tables.
Go to Top of Page

- Advertisement -