RE: Users and Truncate Table

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

Date: Tue, 30 Aug 2005 05:55:42 -0700

yes 

-- 
Jose de Jesus Jr. Mcp,Mcdba
Data Architect
Sykes Asia (Manila philippines)
MCP #2324787
"Ben" wrote:
> 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

Relevant Pages

  • Re: is there a better way to do this???
    ... Any arbitrary row may be returned. ... "jose g. de jesus jr mcp, mcdba" <jose g. de jesus jr mcp, ...
    (microsoft.public.sqlserver.programming)
  • opening port 1433 to the web
    ... Jose de Jesus Jr. ... Sykes Asia (Manila philippines) ... MCP #2324787 ...
    (microsoft.public.sqlserver.security)
  • RE: Create table rights
    ... DB_DDLADMIN rights to the database. ... "Jose G. de Jesus Jr MCP, ... > Jose de Jesus Jr. ...
    (microsoft.public.sqlserver.security)
  • Re: Bubba Betrays the Troops
    ... >>> That would be 'Resistance to change' again. ... >>> Jesus the researchers could have saved their time and just ... Maybe you and Jose No Se should join up and form Johnnie and Jose ... You only continue to spin your own blather and idiocy! ...
    (alt.politics.bush)
  • RE: SELECT Command - For beginner.
    ... Jose de Jesus Jr. ... Data Architect ... Sykes Asia ...
    (microsoft.public.sqlserver.datamining)