Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 05 Jun 2003 @ 19:39:04 GMT


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


Subj:   Re: Restrict Fallback on a Database
 
From:   Adam DeYoung

If a user has CREATE/DROP TABLE on a database, they can add or drop fallback on the tables within it. By revoking those rights you can prevent users from adding fallback. For development databases where users need to create their own tables for testing, you can't do much to prevent it other than create a "no fallback" policy and hope they adhere to it. To enforce that policy you could schedule a script to run on a regular basis that identifies all fallback tables that should not be fallback and alter them to no fallback.

Adam
Advanced Teradata Certified Professional



     
  <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