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

ColumnName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

TVFields.FieldName

AccessRight

CHAR(2) LATIN

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(2)

AccessRights.AccessRight

GrantAuthority

CHAR(1) LATIN

UPPERCASE

NOT NULL

X(1)

AccessRights.WithGrant

GrantorName

VARCHAR(128)

UNICODE

UPPERCASE

NOT CASESPECIFIC

X(128)

Dbase.DatabaseNameI (UPI)

CreatorName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

Dbase.DatabaseName

CreateTimeStamp

TIMESTAMP(0)

YYYY-MM-DDBHH:MI:SS

AccessRights.CreateTimeStamp

To display the privileges that the user has been granted on database D, the SELECT statement must specify:

WHERE DatabaseName = ’D’ AND TableName = ’All’ ;

If privileges have been granted on the database, a row is returned for each privilege.

The UserRightsV view does not return information about implicit privileges of a user due to ownership of objects, nor does it return information about privileges inherited by a user from PUBLIC or roles.

To obtain information about privileges inherited from roles, use the UserRoleRightsV view. For implicit privileges, use the ChildrenV[X] and TablesV[X] views to determine all the objects owned by a user.

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

The following SELECT statement displays information about all tables in the Personnel database on which privileges were granted to the requesting user.

==> SELECT * FROM DBC.UserRightsV
       WHERE DatabaseName=’Personnel’
       AND TableName = ’All’ ;

Result:

DatabaseName   ­TableName     ­AccessRight     ­GrantorName
------------   ---------     -----------     -----------
Personnel      Employee            R          DBC
Personnel      Employee            U          DBC
Personnel      Employee            I          DBC