i have a user who has delete rights on a table, but when i call truncate
table statement it says not enough permission.
how to assign truncate rights

BOL says:
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.





Show quoteHide quote

In 2000, you can't grant this. You need to be table owner or higher. In 2005, you have some options.
From 2005 Books Online, TRUNCATE TABLE:

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.




Show quoteHide quote

SQL Server vs the Competition
Date Only Data Type
Time Calculation - NEED HELP PLEASE!
Array?
10 seconds for MoveFirst on a rowset?