RE: Users and Truncate Table

From: Ben (ben_1_)
Date: 08/30/05 

Date: Tue, 30 Aug 2005 05:25:25 -0700

I understand where your comming from. However, I need the tables to remain
intact for a unspecified duration of time. My application works like this:
-the user opens the ADP file
-If new data is available, the user runs the upload portion of the program
(this is where those calculated tables must be cleaned and recreated)
-run reporting

a user may not upload any new data and only require reports, so they need
access to these tables. I had tried to use views to accomplish the same
structure, however views took too long to process (a problem i could never
figure out)

if i give a use ddladmin rights, will they be allowed to perform drop and
create statements?

thanks,
Ben

"Jose G. de Jesus Jr MCP, MCDBA" wrote:

> 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