What is the least privileged role that a user needs to truncate a table. The delete permission does not seem to have a control over truncate command. I need to allow the batch operator to be able to truncate the staging tables. This opertator should have the minimum pernmissions. This is for DTS on SQL 2K
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.
So, you can assign the db_ddladmin privs.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply