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. |