Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 14 Jan 2004 @ 09:38:19 GMT

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

Subj:   Re: One power id or many power ids ?
From:   Frank O Connor


We use multiple different ids in our environment.

The reason for this is as follows:

We have similar applications running in several different divisions in our company. We use the same load and sql scripts for each of them. There is one power useid for each of them. Each of these power ids has the power to load and modify data in the databases for that division. However, it has no power to do this for the other divisions.

Say for example, for division a, you have a POWERa user. If you get mixed up, and try and load data to division a using POWERb's logon, the job will fail. We contend that a failed job is better than contaminated data!!!

Naturally, this is not totally fool proof, but it helps.



  <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