15.10 - User_Default_JournalsV[X] - 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)

Schema

DBC

 

View Column

Data Type

Format

Source Table.Column

UserName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

Journal_DB

VARCHAR(128)

UNICODE

NOT CASESPECIFIC NOT NULL

X(128)

Dbase.DatabaseName

JournalName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName (NUSI)

The X view references these additional tables:

  • DBC.AccessRights
  • DBC.DBase
  • DBC.Owners
  • DBC.RoleGrants
  • DBC.Roles
  • DBC.TVM
  • The following SELECT statement selects information on each user database to which the requesting user has access, and for which a default journal table is defined.

    ==> SELECT * FROM DBC.User_Default_JournalsVX;

    Result:

    UserName    ¬≠Journal_DB    ¬≠JournalName
    --------    ----------    -----------
    Usr1          Usr1        Usr1Jrnl
    Usr2          Usr2        Usr2Jrnl
    Usr3          Usr3        Usr3Jrnl