Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 22 Mar 2005 @ 17:27:17 GMT


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


Subj:   Java - Teradata updates
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, March 22, 2005 11:50 -->

Hi,

We have few reference tables in teradata, which users can update, whenever required. Until now, we had been doing this through use of macros for which users had the access to execute.

We have a requirement to make this with GUI front-end (java based). We need to keep the log/details of who updated what and when.

Need your valuable suggestions on how best this can be done. As of now, we can think of following options:

a) Defining one teradata userid for the whole application, which will have update access to the database. User id which is used to update the database will be logged in a separate table for audit trail

b) Letting individual user ids to have update access to the database and the usage will be logged in a separate table for audit trail

c) Create macros for updates, and let individual user ids to have exec access to the macros and the usage will be logged in a separate table for audit trail.

d) any more please..


Thanks and Regards



     
  <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