Post reply

Granting Truncate rights to certain tables

  • August 14, 2003 at 7:40 am

    #162130

    I've created logins that are used in certain DTS packages. In the DTS package, certain tables need to be truncated. Does giving the login ddladmin rights on a database allow the user to truncate all tables? How can I change it so the login can only truncate certain tables.

    Thanks!

  • August 14, 2003 at 9:15 am

    #469981

    From 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."

  • August 14, 2003 at 2:25 pm

    #470020

    So if I give a login db_ddladmin database roles, then can it truncate all tables in the database? I only want a certain login to be able to truncate only certain tables.

    thanks.

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

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