AllRightsV[X] - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
prb1610499325399.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

Category: Accounting

Database: DBC

View Column Data Type Format Comment
UserName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of a user to whom the privilege was granted.
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of the database on which a privilege was granted. The possible values are: ALL/PUBLIC.
TableName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the name of a table, view, stored procedure, trigger, macro, user-defined types, user-defined methods, or user-defined function on which a privilege was granted.
ColumnName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the column name to which a privilege has been granted.
AccessRight CHAR(2) LATIN UPPERCASE NOT NULL X(2) Returns a code that identifies a privilege granted on the object.
GrantAuthority CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns the WITH GRANT OPTION attribute of the access right held by the user.
GrantorName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the grantor who granted the privilege.
AllnessFlag CHAR(1) LATIN UPPERCASE NOT NULL X(1) Returns Y (yes) or N (no) to indicate whether or not the privilege was granted to all subordinate users, or to all users who are owned by the grantee.
CreatorName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Table or database creator. For DBC.AllRights, the grantor of explicit rights, otherwise the user who executed the CREATE statement.
CreateTimeStamp TIMESTAMP(0) YYYY-MM-DDBHH:MI:SS Returns the date and time that the object in the row was created.