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

Security

DBC

 

View Column

Data Type

Format

Source Table.Column

RoleName

VARCHAR(128)

UNICODE

NOT NULL

X(128)

Roles.RoleName

CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

Dbase.DatabaseName

CommentString

VARCHAR(255)

UNICODE

X(255)

Roles.CommentString

CreateTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

Roles.CreateTimeStamp

ExtRole

CHAR(1) LATIN

UPPERCASE

NOT NULL

X(1)

Roles.ExtRole

The following SELECT statement returns the names of the role creators:

==> SELECT rolename (char(8)), creatorname (char(8)), commentstring (char(20)), createtimestamp, ExtRole from DBC.RoleinfoV;

Result:

RoleName  CreatorName  CommentString         CreateTimeStamp     ExtRole
--------  -----------  --------------------  ------------------- -------
r1        u1           Comments on r1        2002-08-13 10:26:19 N
r2        u2           Comments on r2        2002-08-13 10:26:25 Y