|
robvolk
Most Valuable Yak
USA
15557 Posts |
 Posted - 02/28/2005 : 07:21:46
|
From Books Online:quote:
Permissions
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. |
 |
|
MS SQL Drop table Permission
