15.10 - UsersV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Database

DBC

 

View Column

Data Type

Format

Source Table.Column

UserName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

CreatorName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

Dbase.CreatorName

PasswordLastModDate

DATE

YY/MM/DD

Dbase.PasswordModDate

PasswordLastModTime

TIME(0)

HH:MI:SS

Dbase.PasswordModTime

OwnerName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

Dbase.OwnerName

PermSpace

FLOAT

NOT NULL

-,---,---,---,---,---,---,--9 (explicit)

Dbase.PermSpace

SpoolSpace

FLOAT

-,---,---,---,---,---,---,--9(explicit)

Dbase.SpoolSpace

TempSpace

FLOAT

-,---,---,---,---,---,---,--9(explicit)

Dbase.TempSpace

ProtectionType

CHAR(1) LATIN

UPPERCASE

NOT NULL

X(1)

Dbase.ProtectionType

JournalFlag

CHAR(2) LATIN

UPPERCASE

NOT NULL

X(2)

Dbase.JournalFlag

StartupString

VARCHAR(255)

UNICODE

X(255)

Dbase.StartupString

DefaultAccount

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

Dbase.AccountName

DefaultDataBase

VARCHAR(128)

UNICODE

X(128)

Dbase.DefaultDataBase

CommentString

VARCHAR(255)

UNICODE

X(255)

Dbase.CommentString

DefaultCollation

CHAR(1) LATIN

UPPERCASE

NOT NULL

X(1)

Dbase.DefaultCollation

PasswordChgDate

DATE

YY/MM/DD

Dbase.PasswordChgDate

LockedDate

DATE

YY/MM/DD

Dbase.LockedDate

LockedTime

INTEGER

99:99

Dbase.LockedTime

LockedCount

BYTEINT

---9

Dbase.LockedCount

TimeZoneHour

BYTEINT

---9

Dbase.TimeZoneHour

TimeZoneMinute

BYTEINT

---9

Dbase.TimeZoneMinute

DefaultDateForm

CHAR(1) LATIN

UPPERCASE

X(1)

Dbase.DefaultDateForm

CreateTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

Dbase.CreateTimeStamp

LastAlterName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

LastAlterTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

Dbase.LastAlterTimeStamp

DefaultCharType

SMALLINT

---,--9

Dbase.DefaultCharType

RoleName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

Dbase.RoleName

ProfileName

VARCHAR(128)

UNICODE

X(128)

Dbase.ProfileName

AccessCount

BIGINT

--,---,---,---,---,---,--9

ObjectUsage.UserAccessCnt

LastAccessTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

ObjectUsage.LastAccessTimeStamp

ExportDefinitionName

VARCHAR(30)

LATIN

NOT CASESPECIFIC

X(30)

ExportWidth.ExportDefinitionName

ExportWidthRuleSet

BYTE(20)

X(40)

ExportWidth.ExportWidthRuleSet

DBA

CHAR(1) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(1)

Dbase.DBA

During a session, the account name may be changed. For the current account name of the session, see “SessionInfoV[X]” on page 305.

For information about the possible values for the JournalFlag column, see Appendix A: “View Column Values.”

DefaultAccount

The DefaultAccount column is the name of the default account, if any, for the user.

Possible Values for DefaultCharType

 

Value

Description

1

Latin

2

Unicode

3

KanjiSJIS

4

Graphic

5

Kanji1

Possible Values for DefaultCollation

 

Value

Description

A

ASCII

E

EBCDIC

H

Host

M

Multinational

C

CharSet_Coll

J

JIS_Coll

Possible Value for DefaultDataBase

If the default database is not defined in a CREATE/MODIFY USER statement, the DefaultDataBase column is the user space and NULL is returned.

Note: At logon, the DefaultDataBase column may be superseded by a default account in a profile, if the user has a profile that specifies a default account.

UserName

For this column, the SYSTEMUSERID is a system user name that tracks console utility activity such as table rebuild, Diskcopy, or Scandisk.

The following SELECT statement displays information about all users owned or created by the current user, Jones.

                 ==> SELECT UserName,CreatorName,PermSpace,SpoolSpace
                     FROM DBC.UsersV;

Result:

                 UserName     ­CreatorName      ­PermSpace      ­SpoolSpace
                 --------     -----------      ---------      ---------- 
                 Jones        sysadmin         1,000,000       1,000,000
                 Peterson     Jones              100,000       1,000,000
                 Moffit       Jones              100,000       1,000,000
                 Chin         Jones              100,000       1,000,000
                 Greene       Jones              100,000       1,000,000
 

For more information about ...

See ...

controlling access, space, and ownership

Database Design.

interpreting the ExportWidthRuleSet column

“ExportWidthV” on page 138.

using the DBSControl utility to make export width definition changes

International Character Set Support.