15.10 - AccountInfoV[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)

Accounting

DBC

 

View Column

Data Type

Format

Source Table.Column

UserName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

AccountName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Accounts.AccountName

UserOrProfile

CHAR(7)

UNICODE

NOT NULL

X(7)

None

You can use this view to query the accounts the user can control.

The following SELECT statement returns the accounts the user controls:

==> SELECT * FROM DBC.AccountInfoV;

Result:

Name               AccountName               UserOrProfile
-------------      -------------             --------------
DBC                DBC                       User
CONSOLE            DBC                       User
SystemFe           SystemFe                  User
Crashdumps         Crashdumps                User
TDPUSER            $H                        User
SysAdmin           SysAdmin                  User
Sys_Calendar       Sys_Calendar              User
V2R5IN             DBC                       User
 

For information about ...

See ...

controlling access, space, and ownership

Database Design.

the current account name (unexpanded) in effect for a session

“SessionInfoV[X]” on page 305.

the default account name for a user or database

“DatabasesV[X]” on page 109 or “UsersV” on page 361.

the default account name if set by profile for a user or database

“ProfileInfoV[X]” on page 199.