truncate – execute as | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

truncate – execute as

Hi all,
what is your proposition in this case. Every day I have to insert new data into Database. Sometimes someone else do this. In sp i have truncate table statment. But this user doesn’t belong to dbo or ddladmin. Is there some posibility to give this user permission to truncate table or run this sp, because this is the fastest way to delete rows from table. Regards,
Rafal
http://msdn2.microsoft.com/en-US/library/ms190384(SQL.90).aspx
http://msdn2.microsoft.com/en-us/library/ms188354.aspx
.. for relevant information, but make sure the security isnot compromised with this feature. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>