List Databases and Users Report Contents - Teradata Administrator

Teradata Administrator User Guide

Teradata Administrator
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Note: The actual column headings are a function of the database itself.


Table 38: List Databases and Users 

Field or Control


Database Name

Name of the database or user.


Type of object where:

D = Database

U = User

Perm Space

Total amount of permanent disk space, in bytes, reserved for the selected database’s use.

Spool Space

Total amount of temporary disk space available to the user for query results and intermediate result files.

Temp Space

Total amount of disk space available for use by Temporary tables built in this database.

Access Count

Number of times the object was accessed since the counter was last reset.

Last Access

Date the object was last accessed.

Account Name

The account associated with this database.

Protection Type

Protection attribute for tables in the selected database:

F = Fallback protection

N = No fallback protection

Journal Flag

Journal default for tables in the selected database where:

N = No journaling

S = Single journal

D = Dual journal

L = Local journal

Note: The journal flag has two characters. The first indicates the before-journal type and the second indicates the after-journal type.

Creator Name

Name of the user that created the object.

Comment String

Comment text associated with the object (A NULL entry indicates no comment).