15.10 - RoleMembersV[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

Grantor

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

Dbase.DatabaseName

WhenGranted

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

RoleGrants.CreateTimeStamp

DefaultRole

VARCHAR(1)

UNICODE

X(1)

None

WithAdmin

CHAR(1) LATIN

UPPERCASE

NOT NULL

X(1)

RoleGrants.WithAdmin

Roles without members are excluded from the result set of RoleMembers.

Possible Values for WithAdmin

 

Value

Description

Y

Yes

N

No

The following query lists all roles and their members:

SELECT CAST(rolename AS CHAR(15)),
       CAST(grantee AS CHAR(20)),
       CAST(grantor AS CHAR(20)),
       whengranted
FROM DBC.RoleMembersV ORDER BY 1,2;

Result:

RoleName     Grantee    Grantor     WhenGranted
----------   --------   --------    --------------------
role_a       user_1     DBA         97-10-15  14:32:59
role_a       user_2     DBA         97-10-15  11:00:01
role_b       user_1     SysFe       98-04-24  09:10:15
. . .        . . .      . . .       . . .