Archives of the TeradataForum

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

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

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>>