Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 07 Apr 2011 @ 13:25:22 GMT

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

Subj:   Re: Dropping User and user created objects

Thank you all who responded to my question.

When developers create tables they are created under their userid.

When they leave their job I was recommended to drop and recreate their tables so that their tables can be recreated as SYSDBA.

But dropping and recreating tables is error prone, I feel and there are so many tables to change.

In DB2 on Mainframe we use one SQL id for each environment such as ABCSP for production and ABCMD for test. Programmers and DBAsl create tables using these ids, so we don't change creator when people leave.

Do people use such ids when they create tables in your job site? Or do they use individual ids to create and the tables get dropped and recreated when they leave?

  <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