X Views | Data Dictionary | Teradata Vantage - 17.00 - X Views - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K
The Unicode X views and compatibility X views contain security constraints in their definition to limit the result set to only the rows associated with the requesting user, such as:
  • Databases
  • Users
  • Objects owned or created by the user
  • Objects on which the user has been granted privileges

The following Unicode X views and compatibility X views also return rows associated with the current role of the user and any nested roles of that current role.

  • DBC.AccessLogV
  • DBC.AccLogRulesV
  • DBC.AccountInfoV[X]
  • DBC.AllRightsV[X]
  • DBC.AllRoleRightsV
  • DBC.AllSpaceV[X]
  • DBC.AllTempTablesV[X]
  • DBC.All_RI_ChildrenV[X]
  • DBC.All_RI_ParentsV[X]
  • DBC.AMPUsageV[X]
  • DBC.ArchiveLoggingObjsV[X]
  • DBC.ARC_SessionInfoVX
  • DBC.AssociationV[X]
  • DBC.AuthoriziationsV[X]
  • DBC.BAR_ChildrenV
  • DBC.BAR_Databases2V
  • DBC.BAR_FunctionsV
  • DBC.BAR_JoinIndicesV
  • DBC.BAR_ownerdbV
  • DBC.BAR_RI_Distinct_ParentsV
  • DBC.BAR_StatsV
  • DBC.BAR_Tables2V
  • DBC.BAR_TablesV
  • DBC.CharsetsV
  • DBC.CharTranslationsV
  • DBC.ChildrenV[X]
  • DBC.CollationsV
  • DBC.ColumnStatsV
  • DBC.ColumnsV[X]
  • DBC.ColumnsqV[X]
  • DBC.ColumnsjqV[X]
  • DBC.ColumnsUseCountV[X]
  • DBC.ConnectRulesV
  • DBC.ConstraintFunctionsV
  • DBC.ConstraintValuesV
  • DBC.CSPSESSIONINFOV
  • DBC.Databases2V[X]
  • DBC.DatabasesV[X]
  • DBC.DatabaseUseCountV[X]
  • DBC.Database_Default_JournalsV[X]
  • DBC.DBCInfoV
  • DBC.DBQLRulesV
  • DBC.DeleteAccessLogV
  • DBC.DeleteOldInDoubtV
  • DBC.DeleteUseCountV [X]
  • DBC.DiskSpaceErrorV
  • DBC.DiskSpaceV[X]
  • DBC.ErrorTblsV[X]
  • DBC.EventsV[X]
  • DBC.Events_ConfigurationV[X]
  • DBC.Events_MediaV[X]
  • DBC.ExportWidthV
  • DBC.ExpStatsV
  • DBC.ExternalSPsV[X]
  • DBC.ForeignTablesInfoV[X]
  • DBC.ForeignTablesV[X]
  • DBC.FunctionAliasInfoV[X]
  • DBC.FunctionAliasV[X]
  • DBC.FunctionsV[X]
  • DBC.HostsInfoV
  • DBC.IndexConstraintsV[X]
  • DBC.IndexStatsV
  • DBC.IndexUseCountV[X]
  • DBC.IndicesV[X]
  • DBC.InDoubtLogV
  • DBC.InsertUseCountV[X]
  • DBC.JoinIndicesV
  • DBC.JournalsV[X]
  • DBC.LoadTablesInfoV[X]
  • DBC.LogOnOffV[X]
  • DBC.LogonRulesV
  • DBC.MapGrantsV[X]
  • DBC.MapsV[X]
  • DBC.MultiColumnStatsV
  • DBC.MultiExpStatsV
  • DBC.ObjectUseCountV[X]
  • DBC.ownerdbV
  • DBC.PartitioningConstraintsV[X]
  • DBC.PeriodsV[X]
  • DBC.ProfileAsgdSecConstraintsV[X]
  • DBC.ProfileInfoV[X]
  • DBC.QryLockLogXMLV
  • DBC.QryLogEventHisV
  • DBC.QryLogEventsV
  • DBC.QryLogExceptionsV
  • DBC.QryLogExplainDocV
  • DBC.QryLogExplainV
  • DBC.QryLogFeatureUseCountV
  • DBC.QryLogFeatureListV
  • DBC.QryLogObjectsV
  • DBC.QryLogParamV
  • DBC.QryLogSQLDocV
  • DBC.QryLogSQLV
  • DBC.QryLogStepsV
  • DBC.QryLogSummaryV
  • DBC.QryLogTDWMV
  • DBC.QryLogTdwmSumV
  • DBC.QryLogUtilityV
  • DBC.QryLogV
  • DBC.QRYLogXMLDocV
  • DBC.QryLogXMLV
  • DBC.QueryStatsV
  • DBC.RCC_ConfigurationV[X]
  • DBC.RCC_MediaV[X]
  • DBC.ReconfigDeleteOrderV
  • DBC.ReconfigInfoV
  • DBC.ReconfigRedistOrderV
  • DBC.ReconfigTableStatsV
  • DBC.RepCaptureRulesV
  • DBC.RepTablesV[X]
  • DBC.ResolvedDTSV[X]
  • DBC.RestrictedWordsV
  • DBC.RI_Child_TablesV[X]
  • DBC.RI_Distinct_ChildrenV[X]
  • DBC.RI_Distinct_ParentsV[X]
  • DBC.RI_Parent_TablesV[X]
  • DBC.RoleInfoV[X]
  • DBC.RoleMembersV[X]
  • DBC.SecConstraintsV[X]
  • DBC.SecurityDefaultsV
  • DBC.SecurityLogV[X]
  • DBC.ServerV[X]
  • DBC.SessionInfoV[X]
  • DBC.SHOWCOLCHECKSV[X]
  • DBC.SHOWTBLCHECKSV[X]
  • DBC.Software_Event_LogV
  • DBC.StatsV
  • DBC.StatUseCountV[X]
  • DBC.Tables2V[X]
  • DBC.Tables3VX
  • DBC.TableSizeV[X]
  • DBC.TableStatsV
  • DBC.TablesV[X]
  • DBC.TableTextV[X]
  • DBC.Table_LevelConstraintsV[X]
  • DBC.TblSrvInfoV[X]
  • DBC.TblSrvV[X]
  • DBC.TempTableStatsV
  • DBC.TriggersV[X]
  • DBC.UDTInfoV
  • DBC.UpdateUseCountV[X]
  • DBC.UserGrantedRightsV
  • DBC.UserRightsV
  • DBC.UserRoleRightsV
  • DBC.UsersV
  • DBC.User_Default_JournalsV[X]
  • DBC.UsrAsgdSecConstraintsV[X]
  • DBC.ViewStatsV
  • DBC.ZonesV[X]
  • DBC.ZoneGuestsV[X]
For example, the DBC.TablesVX and DBC.TablesX views provide the following information for each table to which the role of the user has access:
  • If the role has privilege on all in TVMs
  • If the role has privilege on this specific TVM

It also depends on the current session role of the user to determine what roles are used to verify privileges.

If the current role is. . . Then . . .
not NULL or ALL the current role and its nested role are used for security checks.
ALL all the role(s) directly granted to the user and all their nested role(s) are used for security checks.

X views run slower than their corresponding non-X versions because the X views have security checks.

Compatibility X views are named the same as their corresponding non-X views followed by the character X.

Unicode X views are named the same as their corresponding non-X views followed by the character V.