Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 25 Feb 2003 @ 19:53:47 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Utility Lock
 
From:   David Wellman

Srini,

A little difficult in Teradata. There's no direct equivalent.

Assuming that your "setup the environment" involves issuing DDL commands then you can't use transaction locks.

Probably your best/safest bet is to revoke everyone's AccessRights for the duration of your processing. This is either

-- at the database level if your talking about setting up tables, views and macros etc within a single Teradata database but you want people to be able to acess other databases on the same machine, OR

-- at the logon level (i.e. remove the ability for people to logon to the machine) if you're talking about setting up an entire Teradata machine.

Dave



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016