sql - 截断表权限

Question

我们需要什么最小权限来截断表？除了 DDLAdmin。什么是授予用户在 SQL 2008 R2 上截断用户的权限的最佳实践

Answer 1

在线书籍中截断表格文档 here

Permissions

The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the db_owner and db_ddladmin fixed database roles, and are not transferable. However, you can incorporate the TRUNCATE TABLE statement within a module, such as a stored procedure, and grant appropriate permissions to the module using the EXECUTE AS clause. For more information, see Using EXECUTE AS to Create Custom Permission Sets.