ExtractDDLforRoles

Generate DDL for a Role in a Teradata Database

There are times I would like to copy the permissions for a role with a Teradata database to use on another database.  Below is a nice query to give me … Continue Reading →


Teradata Check Query DDL

Query to Check the Last Time a Teradata View was Rebuilt or Altered

Recently I was asked to update a couple of views on a Teradata database.  This script was an easy way to verify that the Teradata views’ timestamp for the DDL … Continue Reading →