Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 20 Jun 2007 @ 13:46:33 GMT


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


Subj:   Re: Locking a Database for READ only
 
From:   RAJESH JAIN

This option is not right.

If you lock Table for "Access" the table is available for insert/update operation by other users. This is used when data integrity/consistency is not of much importance while you need read on data.

What is actually needed is to put "read" lock on the Base Table.

If the base table is directly referenced, i.e without any view, then by default "Read" lock is put on the table. But if you are going to access the table via a view, then make sure that the view definition includes :

     Locking  For Read

Regards,

Rajesh



     
  <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: 15 Jun 2023