Post reply

Permissions and role to truncate table

  • March 9, 2006 at 7:06 am

    #116426

    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 10, 2006 at 3:02 am

    #625879

    Look up TRUNCATE TABLE in BOL:

    Permissions

    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.

    All these roles give quite broad permissions in the DB, except table owner which is probably also not the best option. TRUNCATE TABLE performs unlogged operations, therefore it is understandable that only admins/owners can issue this command.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply