15.10 - UserGrantedRightsV - 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

DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

TableName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMName (NUSI)

ColumnName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVFields.FieldName

Grantee

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseName

AccessRight

CHAR(2) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(2)

AccessRights.AccessRight

GrantAuthority

CHAR(1) LATIN

UPPERCASE

NOT NULL

X(1)

AccessRights.WithGrant

AllnessFlag

CHAR(1) LATIN

UPPERCASE

NOT NULL

X(1)

AccessRights.AllnessFlag

CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

Dbase.DatabaseName

CreateTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

AccessRights.CreateTimeStamp

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

Possible Values for AllnessFlag

 

Value

Description

Y

Yes

N

No

The following SELECT statement displays all privileges that the current user has granted to other users.

==> SELECT DatabaseName,TableName,Grantee,AccessRight
       FROM DBC.UserGrantedRightsV;

Result:

DatabaseName   ­TableName     ­Grantee   ­AccessRight
------------   ---------     -------   -----------
Personnel      Employee      Greene        R
Personnel      Employee      Greene        U
Personnel      Employee      Greene        I