If the SELECT privilege on one or more system views is revoked or not granted to PUBLIC, you can use the HELP and COMMENT statements to obtain directory information about a particular object for which you have access.
HELP does not require long or complex queries and the results can be formatted for printing.
The COMMENT statement returns descriptive information about a database or database object. This includes information about Data Dictionary views.
For example, the following COMMENT statement:
COMMENT ON DBC.UserGrantedRightsV;
returns the following description:
The DBC.UserGrantedRightsV view provides information on access rights that the current user has granted to other users. The column names are: DatabaseName, TableName, FieldName, Grantee, AccessRight, WithGrant and AllnessFlag.
For more information on HELP and COMMENT, see Teradata Vantageā¢ - SQL Data Definition Language Syntax and Examples, B035-1144.