Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
albi607
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)? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-02-28 : 07:21:46
|
From Books Online:quote:
PermissionsDROP 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