17.00 - AccLogRulesV - 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

Category: Security

Database: DBC

View Column Data Type Format Comment
UserName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) The AccLogRulesV.UserName field shows the user to which the access logging rule applies. It may be 'All' to say all users.
DatabaseName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the database or user name of the object for which this log entry was made.
TVMName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the table, view, stored procedure, macro, user-defined types, user-defined methods, or user-defined function name of the object for which this log entry was made.
ConstraintName VARCHAR(128) UNICODE UPPERCASE NOT NULL X(128) The AccLogRulesV.ConstraintName field shows security constraint to which the access logging rule applies. It may be 'All' to say all security constraints.
AcrAlterFunction CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrAlterFunction field shows the logging in effect for the Alter Function privilege on the object(s) and/or users to which the rule applies.
AcrCheckPoint CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrCheckPoint field shows the logging in effect for the CHECKPOINT privilege on the objects or users (or both) to which the rule applies.
AcrCreateDataBase CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrCreateDataBase field shows the logging in effect for the CREATE DATABASE privilege on the objects or users (or both) to which the rule applies.
AcrCreateFunction CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrCreateFunction field shows the logging in effect for the CREATE FUNCTION privilege on the objects or users (or both) to which the rule applies.
AcrCreateMacro CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrCreateMacro field shows the logging in effect for the CREATE MACRO privilege on the objects or users (or both) to which the rule applies.
AcrCreateTable CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrCreateTable field shows the logging in effect for the CREATE TABLE privilege on the objects or users (or both) to which the rule applies.
AcrCreateUser CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrCreateUser field shows the logging in effect for the CREATE USER privilege on the objects or users (or both) to which the rule applies.
AcrCreateView CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrCreateView field shows the logging in effect for the CREATE VIEW privilege on the objects or users (or both) to which the rule applies.
AcrCreateProcedure CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrCreateProcedure field shows the logging in effect for the CREATE PROCEDURE privilege on the objects or users (or both) to which the rule applies.
AcrCreExtProcedure CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrCreExtProcedure field shows the logging in effect for the CREATE EXTERNAL PROCEDURE privilege on the objects or users (or both) to which the rule applies.
AcrDelete CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrDelete field shows the logging in effect for the DELETE privilege on the objects or users (or both) to which the rule applies.
AcrDropDatabase CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrDropDatabase field shows the logging in effect for the DROP DATABASE privilege on the objects or users (or both) to which the rule applies.
AcrDropFunction CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrDropDatabase field shows the logging in effect for the DROP FUNCTION privilege on the objects or users (or both) to which the rule applies.
AcrDropMacro CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrDropMacro field shows the logging in effect for the DROP MACRO privilege on the objects or users (or both) to which the rule applies.
AcrDropTable CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrDropTable field shows the logging in effect for the DROP TABLE privilege on the objects or users (or both) to which the rule applies.
AcrDropUser CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrDropUser field shows the logging in effect for the DROP USER privilege on the objects or users (or both) to which the rule applies.
AcrDropView CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrDropView field shows the logging in effect for the DROP VIEW privilege on the objects or users (or both) to which the rule applies.
AcrDropProcedure CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrDropProcedure field shows the logging in effect for the DROP PROCEDURE privilege on the objects or users (or both) to which the rule applies.
AcrDump CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrDump field shows the logging in effect for the DUMP privilege on the objects or users (or both) to which the rule applies.
AcrExecute CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrExecute field shows the logging in effect for the EXECUTE privilege on the objects or users (or both) to which the rule applies.
AcrExecuteFunction CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrExecuteFunction field shows the logging in effect for the EXECUTE FUNCTION privilege on the objects or users (or both) to which the rule applies.
AcrExecuteProcedure CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrExecuteProcedure field shows the logging in effect for the EXECUTE PROCEDURE privilege on the objects or users (or both) to which the rule applies.
AcrGrant CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrGrant field shows the logging in effect for the GRANT privilege on the objects or users (or both) to which the rule applies.
AcrIndex CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrIndex field shows the logging in effect for the CREATE/DROP INDEX privilege on the object(s) or users (or both) to which the rule applies.
AcrInsert CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrInsert field shows the logging in effect for the INSERT privilege on the objects or users (or both) to which the rule applies.
AcrReference CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrReference field shows the logging in effect for the Reference privilege on the object(s) or users (or both) to which the rule applies.
AcrRestore CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrRestore field shows the logging in effect for the RESTORE privilege on the objects or users (or both) to which the rule applies.
AcrSelect CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrSelect field shows the logging in effect for the SELECT privilege on the objects or users (or both) to which the rule applies.
AcrUpdate CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrUpdate field shows the logging in effect for the Update privilege on the object(s) and/or users to which the rule applies.
AcrCreateTrigger CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrCreateTrigger field shows the logging in effect for the CREATE TRIGGER privilege on the objects or users (or both) to which the rule applies.
AcrDropTrigger CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrDropTrigger field shows the logging in effect for the DROP TRIGGER privilege on the objects or users (or both) to which the rule applies.
AcrCreateRole CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the logging in effect for the CREATE ROLE privilege.
AcrDropRole CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the logging in effect for the DROP ROLE privilege.
AcrCreateProfile CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the logging in effect for the CREATE PROFILE privilege.
AcrDropProfile CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the logging in effect for the DROP PROFILE privilege.
AcrAlterProcedure CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrAlterProcedure field shows the logging in effect for the Alter Procedure privilege on the object(s) and/or users to which the rule applies.
AcrRepControl CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrRepControl field shows the logging in effect for the RepControl privilege on the object(s) and/or users to which the rule applies.
AcrAlterExtProcedure CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrAlterExtProcedure field shows the logging in effect for the ALTER EXTERNAL PROCEDURE privilege on the objects or users (or both) to which the rule applies.
AcrUDTUsage CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the logging privilege checks corresponding to privileges for UDTUsage.
AcrUDTType CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the logging privilege checks corresponding to privileges for UDTType.
AcrUDTMethod CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the logging privilege checks corresponding to privileges for UDTMethod.
AcrCreAuthorization CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrCreAuthorization field shows the logging in effect for the CREATE AUTHORIZATION privilege on the objects or users (or both) to which the rule applies.
AcrDropAuthorization CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrDropAuthorization field shows the logging in effect for the DROP AUTHORIZATION privilege on the objects or users (or both) to which the rule applies.
AcrStatistics CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrStatistics field shows the logging in effect for the Statistics privilege on the object(s) and/or users to which the rule applies.
AcrShow CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrShow field shows the logging in effect for the SHOW privilege on the objects or users (or both) to which the rule applies.
AcrCreOwnerProcedure CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrCreOwnerProcedure field shows the logging in effect for the CREATE OWNER PROCEDURE privilege on the objects or users (or both) to which the rule applies.
AcrConnectThrough CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the logging in effect for the CTControl privilege on the users to which the rule applies.
CreatorName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL 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.
AcrCreateGLOP CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the access logging rules for the CREATE GLOP privilege.
AcrDropGLOP CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the access logging rules for the DROP GLOP privilege.
AcrGLOPMember CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the access logging rules for the GLOP MEMBER privilege.
AcrConstrDef CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrConstrDef field shows the logging in effect for the Constraint Definition privilege on the object(s) and/or users to which the rule applies.
AcrConstrAsgn CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrConstrAsgn field shows the logging in effect for the Constraint Assignment privilege on the object(s) and/or users to which the rule applies.
AcrOverrideIns CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrOverrideIns field shows the logging in effect for the Override Insert privilege on the object(s) and/or users to which the rule applies.
AcrOverrideSel CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrOverrideSel field shows the logging in effect for the Override Select privilege on the object(s) and/or users to which the rule applies.
AcrOverrideUpd CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrOverrideUpd field shows the logging in effect for the Override Update privilege on the object(s) and/or users to which the rule applies.
AcrOverrideDel CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrOverrideDel field shows the logging in effect for the Override Delete privilege on the object(s) and/or users to which the rule applies.
AcrOverrideDump CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrOverrideDump field shows the logging in effect for the Override Dump privilege on the object(s) and/or users to which the rule applies.
AcrOverrideRestore CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrOverrideRestore field shows the logging in effect for the Override Restore privilege on the object(s) and/or users to which the rule applies.
AcrCreateZone CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrCreateZone field shows the logging in effect for the Create Zone privilege on the object(s) and/or users to which the rule applies.
AcrDropZone CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrDropZone field shows the logging in effect for the Create Zone privilege on the object(s) and/or users to which the rule applies.
AcrZoneOverride CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) The AccLogRulesV.AcrZoneOverride field shows the logging in effect for the Create Zone privilege on the object(s) and/or users to which the rule applies.
AcrCreateDatasetSchema CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the logging in effect for the CREATE DATASET SCHEMA privilege.
AcrDropDatasetSchema CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the logging in effect for the DROP DATASET SCHEMA privilege.
AcrWithDatasetSchema CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the logging in effect for the WITH DATASET SCHEMA privilege.
AcrCreateMap CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the logging in effect for the CREATE MAP privilege.
AcrDropMap CHAR(3) LATIN NOT CASESPECIFIC NOT NULL X(3) Returns the logging in effect for the DROP MAP privilege.