Security-Related System Views - Teradata Vantage - Analytics Database

Database Introduction

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-09-27
dita:mapPath
gtm1628096154303.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
dsm1472253642401
lifecycle
latest
Product Category
Teradata Vantageā„¢

The Data Dictionary includes the following security-related system views.

View Description
DBC.AccessLogV Each entry indicates a privileges check that resulted from a user request.
DBC.AccLogRulesV Lists access logging rules for each BEGIN LOGGING and END LOGGING statement pair. The database uses these rules to determine access logging criteria for an individual user or database object.
DBC.LogOnOffV Lists all logon and logoff activity.
DBC.LogonRulesV Lists the logon rules that result from GRANT and REVOKE LOGON statements. The database uses these rules to determine whether to allow logon privileges to an individual user.

For a complete listing of security-related system views, see Teradata Vantageā„¢ - Analytics Database Security Administration, B035-1100.