We have a table that we have permission to update; the update triggers a
stored proc that includes a truncate table statement. My users don't belong
to the dbowner or ddladmin roles, and the truncate table is failing with
permission denied. Any ideas? There is no "Grant truncate table" statement
(truncate table permission is not transferrable?).

Thanks...

_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement


MS Sql Server LazyDBA home page