Post reply

Truncate table in SQL 2K

  • March 9, 2006 at 7:05 am

    #152815

    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

  • March 9, 2006 at 7:21 am

    #625671

    From BOL:

    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