The Data Dictionary provides a number of security-related system views, including the following.
View | Description |
---|---|
DBC.AccessLogV | Each entry indicates a privileges check that has resulted from a user request. |
DBC.AccLogRulesV | Lists the access logging rules contained in each BEGIN and END LOGGING statement. These rules are used by the database to determine the access logging criteria for a particular 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. These rules are used by the database to determine whether or not to allow logon privileges to a particular user. |
For a complete listing of security-related system views, see Teradata Vantageā¢ - Advanced SQL Engine Security Administration, B035-1100.