RE: Users and Truncate Table

From: Jose G. de Jesus Jr MCP, MCDBA (Email)
Date: 08/30/05 

Date: Tue, 30 Aug 2005 05:10:04 -0700

if your just using the table for aggregating
and temporary storage of a calculated result
might as well use temporary tables instead.
it automatically destroys it self when the
connection goes out of scope 

-- 
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"Ben" wrote:
> How can i set up a use that is able to run a stored procedure that truncates 
> a specific table?  I could swap the truncate for a drop table and create 
> table statement if that works better.  The tables the user will be truncating 
> only contain summaries of the real data so i believe there isnt a worry of 
> security
> 
> thanks for the help!
> ben